I have a system where I need users to enter data into some table, form etc. and then the master form perform calculations based on that information. (Example user enters “Black” into a color field C1 and “1001” into an item number field I1. I tell the program if C1 = “black” then set item number to “1001” and etc… I want the users to enter the data only one time in one place but it be available for all documents to pull from.
I realize I can have users enter data on a form, pull from the form into a view column and use @dblookup to retrieve the column information but felt there might be a cleaner way to accomplish this.
Any suggestions on the best way to handle this?
Subject: Best Way To Handle User Maintained Data
I’m not sure I understand what you want to do. Do you mean that multiple users will each create 1 “configuration” form, and the data from certain fields on each of those documents will populate multivalue field choices on another form (listbox, dialog list, checkboxes, etc.)?
Or do you mean that there should be one configuration document, with one set of fields, which can be edited by multiple users, and you want the data from this single document to be used to compute fields on many other documents?
If it’s the second instance, that’s exactly what profile documents are for. Create one database profile document, which can be edited by a group of administrators (or whoever). Then, use @GetProfileField in your other documents to compute values using the data in the profile document.