Cascade Delete Disabled?

[GarstonMassive]

A simple question I'm sure -

I've created some ref integrity between 5 tables in total but on all of the links the checkboxes that allow me to set "Cascade Delete" etc are disabled.

How do I enable them?

 

[Remou]

Have you ticked the Enforce Referential Integrity box?

 

[GarstonMassive]

Thanks for your reply Remou but even this box is disabled.

I know I'm being stupid.....

 

[PHV]

Are the ForeignKeys indexed ?
Are the ForeignKeys referencing PrimaryKeys ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[GarstonMassive]

Actually chaps I knew it would be something simple.

I found this thread very useful:

thread705-552000

Thanks anyways.