Help with lookup and change value please

Hi,

I have a table called Equipment List

Item Id - key
Location
ect…

I have a table Requests
Request No - Key
Item Id
Current Location
Requested by site
etc…

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”) ??

0 11 350
11 REPLIES 11
Top Labels in this Space