asked on FM - Is There a Way to Make a Value List Dynamic?
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?
Thank you.
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?
Thank you.
FileMaker Pro
Last Comment
rvfowler2
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
A good solution, but I do hesitate to give user ability to delete and replace text throughout a db. Could be trouble.
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.
ASKER
Good idea; thanks.