Hey Guys,
Having trouble getting a reference from a reference. Its returning the ID instead of the Column I want.
Im over simplifying but lets say I have 3 tables.
Table A.
2 Columns. ID and Part Category
Table B.
3 Columns
ID, Part Name and (Part Category referenced from Table A)
Table C
3 Columns
ID, Machine Name, (Part Name Referenced from Table B)
I Have a virtual Column in Table C called Part Category. I need this to display the category of the part that is related to the machine.
Ive Tried
[Part Name].[Part Catagory]
[Part Name].[Part Catagory].[Part Catagory]
[Part Name].[Part Catagory].TableA[Part Catagory]
Many other things, some dont work, some only return the ID of the row,
Any help is appreciated,
Thanks,
Solved! Go to Solution.
Hi @Jonathan_S,
If I have understood your requirement correctly, please create a ref type VC column called say [AB Reference] in table C with an expression something like
[Part Name Referenced from Table B].[Part Category referenced from Table A]
Here [Part Name Referenced from Table B] and [Part Category referenced from Table A] are both assumed to be reference type columns from respective tables as you have described.
For this dual reference columnโs [AB Reference], for the Source Table Settings in column settings pane , please select โTable Aโ
Now please pull the [Part Category] from table A in another VC called say [Part Category Table C] in table C with an expression something like [AB Reference].[Part Category] where [Part Category]is the part category column name in Table A
Hope this helps.
Hi @Jonathan_S,
If I have understood your requirement correctly, please create a ref type VC column called say [AB Reference] in table C with an expression something like
[Part Name Referenced from Table B].[Part Category referenced from Table A]
Here [Part Name Referenced from Table B] and [Part Category referenced from Table A] are both assumed to be reference type columns from respective tables as you have described.
For this dual reference columnโs [AB Reference], for the Source Table Settings in column settings pane , please select โTable Aโ
Now please pull the [Part Category] from table A in another VC called say [Part Category Table C] in table C with an expression something like [AB Reference].[Part Category] where [Part Category]is the part category column name in Table A
Hope this helps.
Thank you
See also Double Dereference Expressions here:
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |