Cascade Explained

starquest321 · Post by **starquest321** » Wed Oct 09, 2013 11:55 am

I have the following situation:

I insert a detail records based on the master table lead index.

So master.lead ----> detail.lead

Now when I update master.email and master.phone I want to populate the results in the detail. I added the two fields in detail field. When I create the record the email and phone are empty. How do I cascade update the phone|email once they are updated?

starquest321 · Post by **starquest321** » Wed Oct 09, 2013 2:18 pm

You cannot add or update a record because the foreign key value does not exist in the master table 'lead'

I have done that - I get this error when I try to update a record.

mobhar · Post by **mobhar** » Wed Oct 09, 2013 3:10 pm

According to the Help file: "Cascade Update --> Specifies that if the primary key for a record in the master table changes, all corresponding records in the detail table will be updated.", then make sure you update the record in the master table, so that the corresponding records in the detail table will be updated, too.

Post by **Webmaster** » Wed Oct 09, 2013 3:28 pm

Do not enable "Referential Integrity" if you allow orphaned detail records.