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

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..