In Access2000 I would like to create a delete query using as criteria a table of selected records to delete from two other tables.
Table #1 lists only the specific serial numbers that I would like use as the criteria. And the other two tables are Inventory and History. All have the serial number in common. The Inventory table has 200 records but the History has about 2000 (because there are multiple records for each serial number).
I've tried to create the delete query but with no success. I am limited in my knowledge of creating queries and would greatly appreciate anyones help. Thanks!
Table #1 lists only the specific serial numbers that I would like use as the criteria. And the other two tables are Inventory and History. All have the serial number in common. The Inventory table has 200 records but the History has about 2000 (because there are multiple records for each serial number).
I've tried to create the delete query but with no success. I am limited in my knowledge of creating queries and would greatly appreciate anyones help. Thanks!