### Title

Relationship oddity

### Post

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.

What you describe attempting is called a conditional value list where the value in one field limits what values appear in the value list specified as the format for another field. While there are a number of different ways that you can set up a conditional value list, the basic, relationship based conditional value list would need a second relationship linking Calc to a different Tutorial: What are Table Occurrences? of Equation so that this new occurrence of Equation can be used as the source of values for your value list.

Calc::adultThreshold = Equation|Threshold::AdultThreshold

You can then set up a "Use values from field" value list listing values from Equation|Threshold with "include only related value starting from Calc" specified.

To learn more about different options for conditional value lists, see: "Adventures in FileMaking #1 - Conditional Value Lists" This file demonstrates 10 different ways to set up a conditional value list.