I have a simple Access query that takes all the fields from one table, and also uses another table with a corresponding field to set a criteria.
The query is the recordsource of a form, and in the form if I try to edit anything I get a message - "This recordset is not updateable".
How can I fix this?
In case it helps, here is my query:
SELECT CartonDimensionsT.*, NewProdT.division
FROM NewProdT RIGHT JOIN CartonDimensionsT ON NewProdT.NewProductBatchID = CartonDimensionsT.BatchID