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.
