Unable to delete record from a main Access table linked to two tables
Posted on 2011-09-11
I have an Access DB (Action) Query with two 3 tables. The first (main) table is linked to two tables. The query displays the code from the main table and the rest of the two columns come from the second and third tables.
When I pressed the Delete button on a record in the query grid, the record gets removed from the grid and prompted "You are about to delete 1 record(s)". Selecting "Yes" goes back to the grid and the deleted record is not displayed.
But closing and re-loading the script, the deleted record still exists. Why is the Delete action was not applied in the database.
I can edit the query column for the record from the secord and third tables without any issue. Edited value persist next time the query is re-loaded.
Thanking you in advance.