13 Replies Latest reply on Feb 14, 2016 6:14 PM by Blue22

    Inserting Foreign field in one table by comparing 2 fields (text and date)



      I am creating a new database. 2 tables have a parent (Inservice) child (Attendee) relationship. Inservice table has all the names and dates of trainings that we offer and with an auto generated Inservice ID field. I have imported data in Attendee table with employee names and training names, dates and other information. I want to match - Title of Inservice (txt field), and training beginning date (date field) and end date (date field) from Inservice table and Attendee table and bring in the Inservice ID associated with that training and fill as foreign key in Attendee table. Any advise...Screen Shot 2016-01-28 at 9.43.17 AM.png