Relationships - Cascade Update and Delete

V

Vayse

Hi
I set up Cascade Update and Delete relationships in a Database Diagram,
within SQL Entreprise Manager.
The relationships were to a Clients table.
If I change the Clients table design within Access ADP, I get message like
the ones below. It removes the Update/Delete that I set up.

'Submissions' table
- Relationship 'Submissions_FK00' is marked for CASCADE UPDATE. This
attribute will be lost.
- Relationship 'Submissions_FK00' is marked for CASCADE DELETE. This
attribute will be lost.
'Motor Vehicles' table
- Relationship 'Motor Vehicles_FK00' is marked for CASCADE UPDATE. This
attribute will be lost.
- Relationship 'Motor Vehicles_FK00' is marked for CASCADE DELETE. This
attribute will be lost.

If I change the Clients table within SQL Server, I don't get this issue.

I prefer to change my tables within my ADP. What should I do?
Thanks
Diarmuid
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Developing a new DB; Organization, Relationships, Cascade Update.. 6
Cascade deletion of referral tables 1
Cascade Delete Relationship Question 2
Cascade Delete and N:N Join Tables 4
How Do I Get My Changed Table Relationships To Be Updated in thelinked Front end? 5
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Update and Delete cascade 0
Master/Detail DataSet delete cascade error 0

Top