delete record from select query and he is still in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I create SELECT qry from 4 tables (relations beetween tables is set to
CASCADE DELETE). When start qry and delete one record from datasheet view,
that record desapear from qry, but he is still in table. When i run qry
second time i dont see that record, like he is deleted, but he is still in
table..

Can anybody help me!

Thanks and sry for my language...
 
Dejan,

Well, it depends on how the query is set up. Sounds like the deletion
is happening to one of the "downstream" tables.

But anyway, if you have Cascade Detetes enabled for the relationships,
you should only need to delete the record directly from the parent
table, and the related records will be deleted without the need of
trying to do it in a query involving all 4 tables.
 

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

Problem with Cross qry 1
Adding New Record to a linked table from Query 1
delete query criteria 6
DELETE QRY issue 4
Union query? 7
eliminate data subset from query 2
Delete Query: Could not delete from specified tables 0
The whole story - Query problem 6

Back
Top