LinkedIn
Twitter
Hi Eveyrone,
I have a problem cannot be solved by my tiny head as shown below:
I have 2 tables "Relocation" and "Inventory"
Inventory is a database to store product data, and Relocation works as a form for me to submit and update the inventory.
As you can see the example data of the inventory, my products happen to have multiple barcodes so i separate the products by barcodes (2 barcodes, 2 rows; 3 barcodes, 3 rows, etc.)
I created two actions as shown below:
full formula of the Trigger - SELECT(Inventory[Barcode], [YuensCode] = [_THISROW].[YuensCode])
both actions run perfectly, but the headache is about the location it updated to my database if you look back to the Inventory example data...
the "Relocation" table will definitely have lots of rows which contain old and new ones. Now i only have two rows, and in the inventory, the PrimaryLocation of "John123" turns to have both data of Relocation.
I tested myself, the PrimaryLocation of John123 in Inventory will only append instead of replace the PrimaryLocation.
What should i do?
What I want to do is everytime i submit a new location to update, the automation will replace the PrimaryLocation with NewPrimaryLocation for all related product (All John123's PrimaryLocation will be update to the submitted one, and will only have 1 PrimaryLocation).
