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.
2 Columns. ID and Part Category
ID, Part Name and (Part Category referenced from Table A)
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.
[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,