By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

deleting record

P: n/a
I have a table1 with a 1 to many relationship to table2.

How can I, scrolling on a form based on table1, with subform based on
table2, delete the active record and make also that the related records of
table2 will automatically be deleted?
txs
Johan
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Johan wrote:
I have a table1 with a 1 to many relationship to table2.

How can I, scrolling on a form based on table1, with subform based on
table2, delete the active record and make also that the related records of
table2 will automatically be deleted?


Set the relationship to be "cascade delete". Deleting the one-side record
will cause related records in table2 to be deleted.

Tools, Relationships, find the relationship line between table1 and table2
and double-click on it and click the Cascade Delete checkbox.

--
'-------------------------------
' John Mishefske
'-------------------------------

Nov 12 '05 #2

P: n/a
Open the Relationships window (Tools menu).
Double-click the line joining the 2 tables.
Check the box for Cascading Delete.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"Johan" <jo***********@pandora.be> wrote in message
news:6L*******************@phobos.telenet-ops.be...
I have a table1 with a 1 to many relationship to table2.

How can I, scrolling on a form based on table1, with subform based on
table2, delete the active record and make also that the related records of
table2 will automatically be deleted?

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.