Friends,

I have two tables joined by a one-to-one relationship. One table is linked from another Access database, so I am not able to check the cascading delete box under the join properties.

Now, when I append records from the linked table to another table in my application I would like to be able to delete records in it when there is a deletion in the records of the linked table.

How would I set up a delete query to find records in my table that are no longer present in the linked table and delete them?

Thanks.

You cannot enforce RI or Cascade Update/Delete across different databases. Consider having all your data tables in one database back-end and multiple front-ends for your multiple purposes. Otherwise you're going to have to run Delete Queries and VBA code and fun things of that nature.