So this might be me having missed a memo on a better way to do this. I’m currently using this code to go up 3 levels, to the Great Gandparent table (Site), from the current table (Material):
ANY(Select(Site[Address],[SiteID]=
ANY(Select(Plot[Site],[PlotID]=
ANY(Select(PO[Plot],[POID]=[_ThisRow].[PO]))
))
))
Is there a simpler way?
LinkedIn
Twitter
