Deleting subform record causes form record to be deleted

J

JerryD

I have two tables in a one to one relationship with Enforce Referential
Integrity NOT selected. I want to delete the subform record but not the form
record. When I attempt to delete the subform record, I get the following
message?

Relationships that specify cascading deletes are about to cause 1 record(s)
in this table and in related tables to be deleted. Are you sure you want to
delete these records?

I delete the subform record and my form record is deleted also.
 
Top