I wanna update the table COMPANY from a linked field. The following is not accepted. Could anybody help me with what the command should be? Thanks a lot. John UPDATE `COMPANY` SET `COMPANY`.Region_ID = ( SELECT `Area`.Region_ID FROM `AREA` WHERE `COMPANY`.Area_ID = `Area`.Area_ID )