create a related global list-of-values in FM10

by Andreas Mastichis | May 2, 2010 | filemaker

The logic is to have the various list-of-values (or combo-values) in a related global table.

1. in global table: create the table that will hold the values -i.e. ‘city’
2. in related table: add an ‘unrelated’ relationship from global of the new ‘city’ table
3. from layout to be used:
   – Manage > Value Lists… > New… > Use values from field > Specify field…
   – find the newly added global table from the list
   – select the name/description of the lov
4. add a field to layout and set the field to use ‘Radio button set’
5. select ‘Display values from’ and select the newly created Value List
6. finally select in which field the values should be stored