Value list context
FM 12. When selecting the first and second fields in a value list, must both fields be in tables that are related to the layout table on which the value list is used?
Neither need be be from a table related to the table where you are using the value list to enter data unless you have selected the "include only related values" option. If the first and second field values are not from the same table, they should be from Tutorial: What are Table Occurrences? related to each other.
Extending FileMaker Pro’s value list sort capabilities using the Char() function
Thinking About Value Lists, part 1 | filemakerhacks
Thinking About Value Lists, part 2 | filemakerhacks
Conditional Value Lists Pt 1 - What Are They & How to Build Them
It’s Sorta a Value List Thing | filemakerhacks
Retrieving data ...