G
Guest
I have a continuous form with its recordsource tied to one table, call it
Table1. However, I also have a Dlookup text box on the form that looks up
data from another table (call it Table2) based on the records returned from
the recordsource. When I delete a record via this form it appears to delete
not only the record in Table1 but also Table2 (which I do not want to
happen). I do not have any relationships explicity defined between these
tables although they do share a primary/foreign key. Do you have any insight
what might be going on? Is the DLookup function causing the record in Table2
to be deleted?
Table1. However, I also have a Dlookup text box on the form that looks up
data from another table (call it Table2) based on the records returned from
the recordsource. When I delete a record via this form it appears to delete
not only the record in Table1 but also Table2 (which I do not want to
happen). I do not have any relationships explicity defined between these
tables although they do share a primary/foreign key. Do you have any insight
what might be going on? Is the DLookup function causing the record in Table2
to be deleted?