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 in Equipment List and change Equipment List - Location to Requests - Requested by Site.
Not sure of what to choose in actions or where to put the lookup expression
Lookup([_thisrow].[Item Id],“Requests”,“Item Id”,“Requested by Site”) ??