1 of 1 people found this helpful
So, when a user enters a date in the one table, why not just (highl evel):
(in a script:)
1. Create a variable with the date entered.
2. Switch layouts to the table with the names for various dates (like Boxing Day)
3. Do a find on that date to see if you have a date with something like "Boxing Day".
4. If Found....return that date text to your other layout.
Would that work?
Use a Card Window (FileMaker Pro 16) to popup with this 'find'.
"They are related via primary key and foreign key."
Why? There is no point in this.
Relate them by the date fields.
I agree, this is a better idea than my script suggestion.
Thank you Bruce, that works a treat. Appreciate your help