Update Query - update same record multiple times
Posted on 2008-06-11
Have the following Update Query:
UPDATE LINK INNER JOIN FORM_ID_358989923 ON LINK.TAG = FORM_ID_358989923.TAG SET FORM_ID_358989923.LOCATION = LINK!LOCATION;
In the LINK table, the Tag may appear several times, and this table is in chronological order, of when assets are moved. TAG is the asset tag, and the link table might have multiple records for that Tag, if were moved several times. The Update query runs, but if the Tag is in more than one record, only the first instance gets updated. Need it to update each time, therefore the last time it appears in the Link Table should be what shows as updated in the FORM_ID table - please help.