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”) ??
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |