i have a query like this on access 2013:
SELECT table1.makatID,table1.Price, table2.Description
FROM table1 LEFT JOIN table2 ON table1.MakatID = table2.makatID;
i have a form that is based on this query. but the problem is that when i delete a record on the form , it's delete the record from table1 and from table 2, but i want that it will not be able do delete any value from table2, and the record will be deleted only from table1, how can i make it with an sql string query.