Is There a Way to Make a Value List Dynamic? Two areas of application: 1) My boss wants the ability when he changes a value list that the actual data in the fields change to match. I'm doubtful about that as it does not seem to be the way value lists work.
2) Fields and script names change in a calc box when you change their names; however value lists do not. I've emailed Filemaker as a suggestion for improvement. Is there a way to make value lists dynamic?
Yes, you reworded my question correctly. So, in the last two paragraphs, you are not suggesting a sub or normalized table, but just a table with 1 record for every value and then create a relationship between that T.O. and the field in the main table? And the relationship as you suggest is by the number, not the text value, thus when you change the text, it changes throughout the dbs?
A good solution, but I do hesitate to give user ability to delete and replace text throughout a db. Could be trouble.
Will Loving
Limit access the editor via checking the privilege set of the account user at the start of the script or simply limit access to the field to Read Only.