unwanted deletion

[simplemind]

hello,
i have 2 tables.
1- customers table with 2 fields : customername,customerno
2-conversationstable with 4 fields: date,customername,customerno,details

the conversations table is for keeping memo of telephone conversations
with the customers.

i built a simple form deriving from the conversations table.
and added to it a combobox with 2 columns from customers table
to select the customername an customerno for the form.

while deleting the record in the conversations table,through the form,
i saw that the customername and customerno in the customers table
of that particular customer record are deleted also.

i made no links between both tables.

i wonder why that happened.

thanks for your help.
simplemind 2013 / Marc / 06

 

[simplemind]

hello Richard,

Many thanks for your quick reply.

the form is made basing on the conversations table,not a query.
i did not create any queries in this mdb,so no links between tables.

i will take your suggestions using different field names and not using
the access reserved ones.

yet,the unwanted deletion still an open question for me.

simplemind 2013/march/06