Edit data in result set when more than a single table has been selected.

Hi, Is it possible to directly edit the data in the result set like when only a single table is selected? As long as selected table parts have enough info to determine the unique row to be updated should it be possible to allow edit of data, despite select being across multiple joined tables. At the moment I can often get the data I want with joined select, but then have to copy and paste the serial id's (or some other scheme to grab rows I need) into another select for just the one table to be altered. It would be much nicer if i could just edit the data first time. Regards, Bryce Stenberg IT Department Harness Racing New Zealand Inc.