Updatable Multi table Query

[meiteniite89]

Hello,

I have created Form based on 2 tables that allows user to update information. One has all the equipment information and the other one contains all the areas that equipment can be found with additional information about area and responsible people.
I linked both tables using Location Code, unique for Area table, but repeats on Equipment table. Now it won't let me update information on the form.
And I can't figure out how to make it work, if I only use one table everything works, but once both tables are used it won't let me.

 

[theDBguy]

Hi. I suggest you use a form/subform setup instead. Each form will be based on only one table, and you just link both forms using the Location Code fileds.

 

[isladogs]

I would agree with the DBguy about using a form/subform.
However, this link gives a clear account of the various reasons why a query may be read only http://allenbrowne.com/ser-61.html