My understanding was that mysql didn't support multi-table updates. I will try the method you mention, but have you successfully done it this way in mysql?
Also, I believe that it is possible to accomplish this kind of multi-talbe update through MS access. Why would it work with the ODBC drivers and access, but not work directly in mysql?
Thanks for the suggestion. Anything else will also be appreciated.