Thx Razzak for the info. I will give a go! Thx again
Dan -----Original Message----- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Tuesday, January 9, 2018 2:49 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - delete from child tables And, here is an example of implementing CASCADE option for table(s) with PRIMARY Keys. See attached screen shot for your viewing pleasure ... Cascade - Maintains primary/foreign key relationships automatically. A CASCADE can be applied to UPDATE, DELETE, or BOTH data set changes for primary keys. For example, if you either UPDATE or DELETE a primary key value from a table, the corresponding foreign key values are updated or deleted automatically. CASCADE can only be added to tables with primary keys. Update - enforces that when a primary key value is updated, the corresponding value in the foreign key table(s) will also be updated. Delete - enforces that when a primary key value is deleted, the corresponding value in the foreign key table(s) will also be deleted. Separate UPDATE and DELETE data restrictions can allow a CASCADE to be enforced for values that are updated, but not enforced when records are deleted, in order to avoid an accidental or undesired record delete. Very Best R:egards, Razzak -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
