Solved: I still need to understand how to make this work (... - Page 2

Tiger1 · 01-08-2020 07:48 AM

Below are my tables. My problem is that i need [item_status] from Table A and [LatLong] from table B to show up in my map view. The issue has been that Table A [Inventory_item_id] does not equal to Table B [Asset ID]. The ids are different:

For Example:
Table A ID - 145
Table B ID - 00000145

So i needed to some how compare and match those ids first, then show on my map - [LatLong] from Table B and the corresponding Item_status for that Asset ID the [Item_status] from Table A.

Bahbus

Yes, you can use a Ref type with a formula. Those new VCs that are your Key columns are now what you need to use as Refs. [Assest ID] in TableB is now ONLY used to feed the new VC. Anything that previously used [Asset ID] should now use the new columns. That was the whole point in creating them.

View solution in original post

I still need to understand how to make this work (if possible)