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?

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?