deleting entries

[Alice]

Thanks for all your help in the past - I'd appreciate some clarity on the following point.

I have a products table, and a transactions table. They have a relationship based on the product code. If I delete a product from the product table, will its associated transactions be deleted as well? I can't seem to understand if that's what my book is saying?

Many thanks,

Alice

 

[dk]

Alice,

I see what you mean now in your other post

To ensure that any related transactions will be deleted do this:-

Open the relationships window by choosing Tools, Relationships. You should see the Transactions and the Products tables. If not, click Relationships, Show All.

Next, there should be a line between Products and Transactions. Right click it and choose Edit Relationship. This will open the Edit Relationship dialog box. Tick the Enforce Referential Integrity and Cascade Delete Related Records. Click OK.

Now, when you delete a 'parent' record from the Products table all of its 'child' records will be deleted.