enforcing referential integrity

[macca007]

Hi i was about to delete tblPatients which has one to many with tblAngioFol. When i went to relationships and tick enforce referential integrity it wouldn't allow me.

How can i check by using a query and show records that the hospital number is not present in tblPatients and vice versa.

I know its not allowing me to enforce referential integrity because of the table on the many side something is not match with tblPatients.

cheers

 

[PHV]

Hi i was about to delete tblPatients which has one to many with tblAngioFol
DELETE * FROM tblAngioFol;
DELETE * FROM tblPatients;

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

 

[Craig0201]

Or allow cascading deletes.

Craig