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
|