By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,098 Members | 1,120 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,098 IT Pros & Developers. It's quick & easy.

Cascaded update/delete box unavaible.

P: n/a
I have a relationship that I createed with a table and subtable in the
relationship editor however the boxes to enable enforce referential
integrity and cascading updates and deletes are disbabled. I want to
enable cascading deletes.

Not sure if this is the issue but I am using linked sql tables however
I am linking for the primary key of the parent table properly.

What do I need to do to be able to enable the check boxes for cascading
deletes?

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
AFAIK, you can't enforce referential integrity on linked tables.

Do that in the original SQL tables.
<td*******@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
I have a relationship that I createed with a table and subtable in the
relationship editor however the boxes to enable enforce referential
integrity and cascading updates and deletes are disbabled. I want to
enable cascading deletes.

Not sure if this is the issue but I am using linked sql tables however
I am linking for the primary key of the parent table properly.

What do I need to do to be able to enable the check boxes for cascading
deletes?

Nov 13 '05 #2

P: n/a
This is the normal behavior with linked tables. You'd have open the tables
at the source to edit their structure or relationships.
-Ed

<td*******@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
I have a relationship that I createed with a table and subtable in the
relationship editor however the boxes to enable enforce referential
integrity and cascading updates and deletes are disbabled. I want to
enable cascading deletes.

Not sure if this is the issue but I am using linked sql tables however
I am linking for the primary key of the parent table properly.

What do I need to do to be able to enable the check boxes for cascading
deletes?

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.