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

    arnojansen1

      Hi,

       

      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.

      Arno