update query on a JOIN Table with a query Not Work

[Boon]

Hi,

I have a table A. Query B which is a select query from Table C.

I am trying to update a field in table A by joining table A with Query B.
Access doesn't allow me to do so. It said the query must be updatable
query...

Thanks for helping out.
B

 

[Duane Hookom]

Generally, you must use tables that join on primary and foreign keys.