Ability to edit fields with more than one table in query?

[rudeboymcc]

Hi. I have a query which has a tick box that i need to be able to change in a form. when the query only has one table in it, this works fine.

However as soon as i add a second table to the query, i can no longer edit the tick box. I've tried changing the relationship but doesn't work.

Is this possible? seems like a simple idea.

 

[boblarson]

Perhaps this will help:
http://allenbrowne.com/ser-61.html