I have 2 tables
Table 1. Table 2.
JobCode JobCode
JobLine JobLine
JobDescription JobDescription
Table 1 is the child record from another database. These records can have new JobLine records added to any of the JobCodes. I need to find these records and then append these new records to Table 2 as table 2 is the child table in my access database.
Unmatched records query does not allow me to look for records which are in Table 1 and not in table 2 as it needs to match JobCode and JobLine which are missing.
Thanking you in advance.
Bill