Drop down menu
Have been using FileMaker for years and my applications are growing, perhaps too large for my knowledge.
Being new to the forum I hope that my question is not too trivial.
I'm have a field named "denomination" and a subsequent field in another layout named "label".
What I'm trying to achieve is a drop down menu that only displays the denominations used in the same (one) record.
At the moment the value list show all denominations in the database.
With hundreds of records with several denominations the list becomes very long!
Would appreciate a suggestion how to solve this problem!