I have a query based on straight, simple, equi (inner) joins on three tables. When the Query is run, I would like to be able change data in one of the columns. When I do this, I get the message "This Recordset is not Updateable".

Any ideas, on how I should tackle this problem. I did search the forum and have seen some one raising a similar issue for one-table query. But, I did not see any resolution.

If there is no way that I can make the query updateable, what is the next best thing I can do. The user wants the ability to see the results in a tabular view and make the changes.

thanks