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.

SOLUTION

Will Loving

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rvfowler2

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

Will Loving

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rvfowler2

ASKER

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.

rvfowler2

ASKER

Good idea; thanks.