Can you post the SQL of the UnMatch record query? -- Good Luck BS"D "BECAM" wrote: > I have two tables which should contain the same information. If one table is > updated and a record removed, i want to create a query that deletes the > record from the other table as well. > > I have created a query which compares the primary keys of two tables and > finds those records that are required to be deleted. How can i create a > query to automatically delete these records. When i create a new delete > query based on this initial query, i get the error "Could not delete from > specified tables". Is it possible to even do what i want?