AnsweredAssumed Answered

Date reference from one table to repeating field in another table

Question asked by EdwardSalm on Nov 22, 2015
Latest reply on Nov 23, 2015 by fentonjones

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?

Outcomes