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

    Date reference from one table to repeating field in another table

    EdwardSalm

      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?