Is it correct that you can not edit/update a recordset which uses more than one table?

If so is the only/best way round this to create a temporary table with the results of the SELECT, then edit/update the temporary table, then use an UPDATE query to update the original table from the temporary table?

That sounds horrible when you try to say it

(Using Access)

Any help much appreciated.