Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete both pages in a record

Status
Not open for further replies.

genericjanedoe

Technical User
Nov 12, 2003
16
GB
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.
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top