This is an old post but revisiting it again as I never got it figured out. Any help very much appreciated.
I have a table called Equipment List
Item Id - key
I have a table Requests
Request No - Key
Requested by site
I want to add an inline action to each row of the requests table.
The Action will look up the Requests - Item Id of that row in Equipment List and change Equipment List.[Location] to Requests.[Requested by Site].
Example of data, looking at Item Id ACC-0001
Equipment List Data:
So the item started in Location SS and was moved to Aberfeldy.
This was manually updated in the Equipment List table so current location is Aberfeldy.
A request was submitted to move this item from Aberfeldy to Location DD.
I want an inline action on each row of the Requests table to automatically update the Equipment List Current Location with the value of Requested by Site from the Requests table.
what I have tried so far.
Action Update Location:
Action Update Delivery: