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

Discussion created by user29517 on Jan 28, 2016
Latest reply on Feb 14, 2016 by Blue22


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