Hi Mary,

Use the Relationships menu to establish this One to Many relationship. While
you're at it, check the option "Cascade Delete".
Cascade Delete exactly the answer you're looking for.

HTH,
Immanuel Sibero



"Mary M" wrote in message
...
If you have a DB setup with a main table linked to a one-to-many table. Is
there a way to delete a record from the main table and have all the one to
many records in the other table be deleted with it at the same time?

Many thanks for any assistance.