Delete Query

[gr]

Hi, to what should I set the Where critria of a Del query
if I only want to delete Records which have no
subdatasheet records?

I have one main table which has 4 subdatasheets. If there
are no records for the corresponding NameID (NameID is in
the main table) in the subtables then delete the item from
the main table.

how?

 

[Darren]

Delete From MainTable where MainTable.Key not in (Select Key from SubTable)