Validating data against two tables

[MTSPEER]

Hello,

I have this database where you can select to import a file and you can press a "Validate" button to run a couple queries to validate the information with another table. The two tables both have the same unique identifier called "GroupName". What I am trying to figure out is how to make sure that the file that is being imported, all the records can be validated by the other table. To make sure all the "GroupName"'s are on each table. I'm not sure if I can use a Recordset, or just a query. If there's a record that's not on the validation table but is on the table that the file was imported to. I want to be able to have a message box appear and let me know that not all the records can be validated. Thanks for you help.

[pbaldy]

Check out the unmatched query wizard. You can use a recordset or domain aggregate function against that.

[MTSPEER]

Ah wow idk how I didn't think of that. thank you

[pbaldy]

Happy to help!