Grandparent to grandchild table--limiting drop down lists only to grandparent records as they appear in parent drop down (once)
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?
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?
