Removing data from table

First, do a backup!

If you edit the relationship between your master and child table(s) and
check the box for Cascade Delete Related Records, when you delete a record in
the master table the child records are automatically deleted.

If you do not have this option enabled and you have set Referential
Integrity (which you usually should do), you will not be able to delete a
master record that has child records, you will have to delete the child
records first.

Steve

"mbing916" wrote:

I am a new access user.

I have two tables, the master and the other table. What is the best way to
remove all the records in the other table from the master? I am struggling
with how to word the query.

Thanks.