What is "Cascade Update Related Fields" and "Cascade Delete Related Records" options?

After referential integrity is established, enabling Cascade Update Related Fields or Cascade Delete Related Records,  will save you quite a bit of code in maintaining the integrity of the data in your system. (Deleting records or updateing records as appropriate.)

If the table where you are deleting records has a relationship with another table and the Cascade Delete Related Records option for that relationship is set, records in the second table will also be deleted.

With Cascade Update Related Fields check update done from the first table is also done in the second table

capricorn1, thank you so much for your kind, prompt response.

I will take time to carefully read your kind tips, and will come back to you.

Thanks again!

if you have a copy of Northwind database,  create another copy and do your experimenting (deleting and updating records) to be able to understand this easily.

TO: LSMConsulting:

Thank you so much for your very valuable, kind tips.

I will keep your kind tips in mind.

TO: All:

Thank you so much for your expertly tips and advices.

Hope you may kindly come back again to help me out  soon!

duta

Scott McDaniel, Thanks for the clarification and sound advice. My mind is at rest now. :)