I have a database with store locations across many states, and they are related to elected officials in each community through a portal. On each official's page, the user selects from a drop-down list of all stores that are in the district of that official. When they have a governor, there are a lot of drop-down selections they need to make (to cover all the store locations across the entire state). Is there some way to set up state choices that will pre-fill the portal rows with stores from that state automatically? Each store's record has a separate state field as part of its address.