This is a quick follow up to my previous article on using a Summary List field as a relational predicate, and transferring a found set from table A to the corresponding found set in table B across that relationship via the Go To Related Record (current record) script step.
To avoid needless repetition, I will assume the reader has read that article. As discussed in the comments section (thank you Mardi Kennedy and Jerry Salem), there is a tried and true method for going to a found set of related records that has worked since FileMaker Pro 3 was released in December 1995:
- Define a global text field
- Link this field relationally to the primary key field of another table
- Populate the global text field with a list of keys
- Go to related records (a.k.a. GTRR)
Continue reading “Global Multiline Key As Relational Predicate”