Lookup Question - text with list error

I am building a proof of presence application that uses NFC tags.

I have two tables Tags and Scans.  

Tags table lists all of the tags attributed to a site and contains tag name (text) and location (Lat Long)

The Scans table also contains tag name and location with the same column types.  Basically when a tag is scanned the tag name is populated into the form, I then need an expression to pull the location for that tag over to the location column in the Scans table.  I have tried lookup however this presents errors as I it says I am comparing text with list.

Please can someone help with an expression for this?

antproberts_0-1724964343114.png

 

Solved Solved
0 4 189
1 ACCEPTED SOLUTION

LOOKUP([_THISROW].[Tag Name],"Patrol Tags","Tag Name","Location") is all that is required.

View solution in original post

4 REPLIES 4
Top Labels in this Space