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

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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?
Photo of Ryan Mcknight

Ryan Mcknight

  • 102 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
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..