Idea is to only update the new record called amount that reside in table 1 and update it to table 2.
I am trying to update amount of assets in a kit. So table named kit is the source and asset table is destination.
The problem I am having is query keeps updating every single record on kit table to asset table.
I am trying to update amount of assets in a kit. So table named kit is the source and asset table is destination.
The problem I am having is query keeps updating every single record on kit table to asset table.
Code:
UPDATE Assets INNER JOIN Kits ON Assets.[Barcode ID] = Kits.[Barcode ID] SET Assets.[In Kit] = [Kits]![Amount]+[Assets]![In Kit];
Comment