I have three tables. "Customers," "Sites," and "Township Officials." Each site has a township listed as a field, which relates to a township in the "Township Officials" table. In the sites table, the township field uses a Combo Box, that draws directly from the Township Officials table (Row Source Type: Table/Query).
Data entry is working great for this relationship. When I go to enter a township in the sites table I see all my townships in the dropdown box that are listed in the "Township Officials" table. That's good. But when I perform a query between the two, my query doesn't pick up all the records that should have a seamless relationship. Please advise.