Fascinating! Thank you for this!
The const_1 calculation field is over my head, but I'll just trust that it is needed to create the relationship.
How could I make the teacher status be a choice of more than two non-numerical options? For example:
Active, On Sabbatical, Fully Booked
When I change the status numbers in the custom value list to words, it works well unil I create more than two options. It also doesn't work if I convert it to drop down vs pop up.
This is just one way to do it.
Their is a fragile dependency on the knowledge of the primary key value for "Sabatical" in this case the number 9...
Until you go any farther you should really grok the use of constants as I have used them herein.
You should also learn how setting the field type definition of the constant fields to global and calculation affects the behavior of related value lists.
The other thing to realize is that the related value lists only operate correctly from the context of a layout based on the main table. Any other context and this will not work.
value_list.fmp12.zip 67.1 K