Grandparent to grandchild table--limiting drop down lists only to grandparent records as they appear in parent drop down (once) | Discussions

Expand all | Collapse all

Grandparent to grandchild table--limiting drop down lists only to grandparent records as they appear in parent drop down (once)

  • 1.  Grandparent to grandchild table--limiting drop down lists only to grandparent records as they appear in parent drop down (once)

    Posted 06-07-2018 18:23
    Grandparent to grandchild table--limiting drop-down lists only to grandparent records as they appear in parent record drop down (only 1 time)

    States:  List of states (related to networks)

    Networks: has a drown down list from states relationship to be associated with the state (parent to providers).

    Providers:  I have providers that need to be associated with the states, or the networks if they are affiliated with a network, or not if they are independent.  In this table, the drop-down list for states (per pass through from Networks) lists multiple VA's for example because there are multiple networks in that state.  How do I have only a state drop down for the independent providers and a network drop down that looks up the networks the providers are associated with (if any)?

    Isn't it inefficient to create a direct relationship from the states table to the providers table?


  • 2.  RE: Grandparent to grandchild table--limiting drop down lists only to grandparent records as they appear in parent drop down (once)

    Posted 06-07-2018 20:44
    Ryan
    The textbook solution will be to have a direct relationship from Sates to Providers to drive the drop down list of States. Presumably the Key field if that table is the State.

    Then set the properties of Related Network on the Providers Table to be a Conditionsl Drop down and limit it to where the State selected is the same as the aerate in the Network.

    If you were to look up that help text on conditional drop down, As I recall that is exactly how they would show the relationship diagram..