can't delete records

[a]

I have query and three table join to each other the join is working good but
I have one problem:

---------

When I delete any records and reopen the query again I find the records not
deleted

What should I do?

Or Whats the wrong?

 

[Jeff Boyce]

When you "delete ... records" are you warned? If not, the SetWarnings has
been turned off, and you are not able to see when Access is having problems.

Can you delete a single record in a single table?

If you have three tables joined, from which table is Access supposed to
delete which record?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

I have query and three table join to each other the join is working good but
I have one problem:

---------

When I delete any records and reopen the query again I find the records not
deleted

What should I do?

Or Whats the wrong?

Your joins are probably done incorrectly. Deleting from a three-table join can
be tricky and requires care. Could you post the SQL of the query, and indicate
what it is that you want deleted?

John W. Vinson [MVP]

 

[a]

thank you for your answer:
I change the realtion between table and now it works
thank you