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

Top