3 Tables and 2 relationship connections:
a. Patient::_CalcID to Calc::__ID
b_ Calc::_EquationID = Equation::__ID
Calc::Adult threshold = Equation::AdultAge
The Equation::Name is displayed as a pop-up in a Calc portal on Patient layout. I'm trying to filter the equations displayed by Calc::Adult threshold. The value list for the pop-up was Equation::__ID & 2nd field Equation::Name.
I haven't been able to successfully limit Equation::Name to only those of the appropriate Calc::Adult threshold.