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!

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

Deleting

Status
Not open for further replies.
EscapeUK

EscapeUK

Programmer
Jul 7, 2000
438
GB
My Db has referential integrity

How can I delete a record from one table and it delete the records it relates to in the other table.

 
Sort by date Sort by votes
Hi Escape!
Piece of cake: To the relationships window please. Double click on your join line to see the joins properties and set that puppy to cascade delete! You are done! Gord
ghubbell@total.net
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

accessbaby
  • Locked
  • Question
How to unlink a page header in access without deleting the data
Replies
1
Views
55
dhookom
dhookom
dongle
  • Locked
  • Question
deleting fields in a table 1
Replies
2
Views
62
dongle
dongle
DajTwo
  • Locked
  • Question
Make table query requires deleting relationship 1
Replies
3
Views
74
fneily
fneily
jmstarbuck
  • Locked
  • Question
Deleting a field 1
Replies
2
Views
44
jmstarbuck
jmstarbuck
kdoran
  • Locked
  • Question
trouble deleting all entries in tables 1
Replies
3
Views
55
kdoran
kdoran

Part and Inventory Search

Sponsor

Back
Top