Preventing a cascading delete.

[RDS2]

This may seem simple but is kiling me to find a solution.

I have an "Information" table (the only table) in a separate DB. To that DB are attached tables from another DB. In the "one table" DB I have a form based on a query that uses the linked table records. I believe that the relationship in question is one to one. (In this instance one job number in the "Information" is joined to one job number in the attached table.)

The problem then becomes if I delete a job "record" from my "Information" table I also get a deletion in the attached table which is not the behavior that I want.

Any suggestions??

 

[TSSTechie]

Hi

Go to the relationships view and double click on the link between the tables. From here you can untick the cascade delete.

Hope this helps

May The Force Be With You

 

[RDS2]

Thanks TSS,

I've tried to edit the relationship. The item that I need to untick is "grayed out". Is this because it is a 1To1 relationship??