I have a FileMaker database I started some years ago for an annual event. Each record is for the event that year. There is a list of the names of participants in a single, repeating field. I know, probably not the best way to have done it.
I've now created a separate table for the names of the participants, each name in a unique record.
How can I show in the new participant table what years those names have been listed in the other table?