Thank you for your post.
You can definitely set up the same value list in different fields.
For this example, let's assume you have the following text fields:
On your layout, select the field "Tree1". Pull down the Format menu and select "Field Control -> Setup..." The default may be set to "Edit box", so change this to Pop-up Menu (or whatever you want), and display values from the value list you have already created. Click OK, and then repeat the same steps for Tree2, Tree3 and Tree4 fields.
If you run into any difficulty, or if you need clarification, please let me know.
if I understood correctly, hazelwize needs to have each fied holding a REDUCED value list, based on the contents of all the other fields.
So, if the list has 12 values, choosed one, has to show only 11 values ... and so on.
This is possible and easy with a custom function that returns a list of values NOT assigned.
Give a look at:
thank you both for your replies! ... i have tried the first method of different fields ... that may work and perhaps better ... what i ended up doing is creating one value list with "custom values" (to keep the order of items) for each "area" where i needed the list ... then i created a "repeating" field of four (which is how many i needed) ... voila! ... this finally worked! ... each "repeat" accesses the value list and allows each one to have a different selection ... this is the critical thing i needed ... unfortunately, this solution will not help me in the future "build" of the file when i want to add the prices, sizes and other criteria to these selections ... which is why i was trying to make some "global" or "value list from field" work ... but this will have to do for now ... i am hoping that the conditional/hierarchal value list info will help when i am ready for that ... i know that a good database is all in the planning and believe me, if it was up to me, i would be able to create for and with the future ... anyway ... i haven't been able to check out the website yet, but will try to find what the second contributor gave me ... thank you!!!