Referencing another table - to show value

I am having trouble with a reference expression.
I have two tables:

Assets (Table A)
Geoforce (Table B)

I created a Virtual column in Table A that ref - Table B:

I use this expression to match up the item.

I then use this virtual column to show the column i want:

I am not getting any values?

The App formula expression for Ref Attached Sling cannot itself itself.

This?

IFS([_Computed Key] = [Ref Attached Sling].[Newcomputedkey], [Ref Attached Sling].[UNTRACKED ASSETS] )

How do i compare the two tables? I have items in both tables with matching ids.

What are you trying to accomplish?

I need to first match the items ( matching the item from both tables) then show the items column (from Table B) [untracked assets] in this table (Table A).

1 Like

I got it Steve - thanks for the help…

1 Like