not deleting related records

L

lynn atkinson

I have various tables displayed together in forms via
queries. We are using them in a multi user environment so
I have split the database in to front end and back end as
recommended. This seems to work OK with data input.
However, I have spent the last 2 days cleaning up some
data and deleting records, but although the records go
through the process of asking for confirmation of
deletion, it does not actually delete the record. In order
to delete I have to go the the table in the back end and
delete it there. Although I can do this, it is more
difficult as I cannot get a full view of all the
information relating to that record which I can view in
the form.

Why does a deletion in the front end not delete the record
in the table in the back end?

What am I missing?
 
Top