Fields from Query joined to Table not updating table

[irunergoiam]

I have a table with an equal join to a query. I would like to take a field from the query and update the table, but I get an error message indicating that this is not an updatable query.

The field from the query is an expression based on a diffferent table. I'm not quite sure why this won't update. Any help would be most appreciated.

Thanks much.

 

[boblarson]

I have a table with an equal join to a query. I would like to take a field from the query and update the table, but I get an error message indicating that this is not an updatable query.

The field from the query is an expression based on a diffferent table. I'm not quite sure why this won't update. Any help would be most appreciated.

Thanks much.

Post the SQL from the query and which table you are wanting updated. I've found that if you try to use the QBE grid it is easy to get it messed up as to which table is actually being updated (or attempted to be updated) and the SQL needs to be adjusted.