6 Replies Latest reply on Jul 27, 2017 3:03 PM by arnojansen1

    I am looking to find if a date in one table is a public holiday via another table




      I need a little help. I have two related tables


      table 1  has primary key, date field, name of the date field. For instance: PK1, 26/12/17, Boxing Day


      table 2 has a date field (and many others) this date field can be any date during the year.


      They are related via primary key and foreign key.


      Now if i type in a date in table 2 that matches a date in in table 1 I would like to see the name of the date field

      So in table 2 I type in 26/12/17 and would like to see Boxing Day etc etc.


      probably easy but I am not seeing the solution right now.


      In Excel i would use a VLookup but don't know the equivalent in FM.


      Working on MAC with Filemaker Pro advanced 14.


      Cheers thanks for your help as always.