Delete both pages in a record

[genericjanedoe]

I have another challenge for you (Thanks to Paul Bent for helping me out of an earlier hole!).

My tracking project database consists of two joined databases each holding different types of information about a record. Each Project is registered on a form that spreads over two pages and incorporates information taken from both databases. I created a delete macro on page 1, which brings up a customised warning, before deleting (in theory) the entire record. However, I have found that all it does is delete the information on page one. When I go into worksheet view, the details on page 2 still exist as a record. I have not found any way of ensuring that the entire record is wiped. Can anyone help? Thanks.

 

[paulbent]

Each form has a main table. When you delete a record it deletes it only from the main table. Related record(s) in joined tables aren't automatically deleted.

In the Join dialog you can select the join line, click Options and specify that when a record in one table is deleted, matching records in the other table are deleted too. Does this fix it?

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[genericjanedoe]

I think this fixes it. You've come to the rescue once again - what a STAR!

A simple fix, but one I'd been tearing my hair out over.

Thanks loads...:-D