How is your value list constructed now.
By usind data in tables your value lists can be managed easier and even be conditional(filtered) based on previous selections if the relationships are constructed properly.
Here's a demo file that demonstrates several "ehanced value selection" techniques. Two of the methods are based on selecting a record in a portal so they'lll show you how to select a value in a portal by clicking that row: http://www.4shared.com/file/plr_jbkk/EnhancedValueSelection.html
Right now our original database system is Filemaker Pro 6, so the lists are defined by the user. Any time a material is added to Materials, I have to manual update list.
I am working on the FM11 trial with hopes to redesign and normalize our system. It is a last ditch effort to stay with FM, the boss feels like we need to go the next step in a DBMS.
I will check out the Value lists in FM11.
You will definitely benefit from Valuelists in FMP11
Wow, that is very powerful. Thank you