I have two tables that are set up in a one to many relationship.
Table 1 has a list on names - no repeats
Table 2 has multiple submissions by the people that are in tbl1. They are submitting an Internet form into an Access table (tbl2). Their name appears multiple times in tb2.
I would like to set up a query that compares the name in tbl2 to the name in tbl1 and show a list of the tbl1 people that do not match. This group would not have submitted any information into tbl2.
Thanks for any help
Table 1 has a list on names - no repeats
Table 2 has multiple submissions by the people that are in tbl1. They are submitting an Internet form into an Access table (tbl2). Their name appears multiple times in tb2.
I would like to set up a query that compares the name in tbl2 to the name in tbl1 and show a list of the tbl1 people that do not match. This group would not have submitted any information into tbl2.
Thanks for any help
