Cross table Delete - elegant query?

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
 
J

jason

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

sorry - Jason
 
M

Michel Walsh

Hi,


Enforce the cascade delete at the design level.

Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Cross Tab Query 1
Using Append Queries with Linked Tables 3
query data from a parent-child table 1
manual deletion of records in datasheet based on joined tables 5
delete query that deletes data in multiple tables 3
Delete Duplicates with a Delete Query 3
Deleting Duplicates 1

Top