Cross table Delete - elegant query?

  • Thread starter Thread starter jason
  • Start date Start date
J

jason

I have just started to master the art of using queries in my asp code and
now hope to go one level higher with regards deleting tables that have
foreign keys...

Could someone provide some starter code on how to delete a table whose
unique id may be used in other tables....

Many thanks
Jason
 
OOOps - I meant to say "delete records across tables that have relationships
defined NOT delete TABLES....

sorry - Jason
 
Hi,


Enforce the cascade delete at the design level.

Hoping it may help,
Vanderghast, Access MVP
 
Back
Top