I have two, what look to be identical tables and queries, yet one allows me to edit the query and one does note. The queries have two inner joins as shown below:
SQL for the query I can edit:
SELECT BaseCoat_Front_shorter.ID_Lot, BaseCoat_Front_shorter.Product, BaseCoat_Front_shorter.Owner, BaseCoat_Front_shorter.Priority, BaseCoat_Front_shorter.Meters_In, BaseCoat_Front_shorter.[Tool_#], Eng_BC_Param_BE_shorter.[Base Thickness]
FROM BaseCoat_Front_shorter INNER JOIN Eng_BC_Param_BE_shorter ON (BaseCoat_Front_shorter.Product = Eng_BC_Param_BE_shorter.Product) AND (BaseCoat_Front_shorter.[Tool_#] = Eng_BC_Param_BE_shorter.[Tool_#]);
SQL for the query I can not edit fields:
SELECT BaseCoat_Front_New.ID_Lot, BaseCoat_Front_New.Product, BaseCoat_Front_New.Owner, BaseCoat_Front_New.Priority, BaseCoat_Front_New.Meters_In, BaseCoat_Front_New.[Tool_#], Eng_BC_Param_BE_New.[Base Thickness]
FROM BaseCoat_Front_New INNER JOIN Eng_BC_Param_BE_New ON (BaseCoat_Front_New.Product = Eng_BC_Param_BE_New.Product) AND (BaseCoat_Front_New.[Tool_#] = Eng_BC_Param_BE_New.[Tool_#]);
When I try to edit the query data fields, Access give me a beep, but no message.
From my examination of the SQL's I do not see a problem. I am thinking there is something about one of the tables that is not allowing me to edit the data. I can change the data in each individual table, just not in the query.
Any ideas?
Thank you for any help. Mike