14 Replies Latest reply on Nov 23, 2015 10:44 AM by fentonjones

    Date reference from one table to repeating field in another table


      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?