Appropriate tables

[XianSPL]

Hey everyone. So I'm creating a database that is going to serve the following funtion. The user will select a city (variable 1) from a drop down and either "professional" (variable 3) or "facility" (variable 4) from another drop down. When the city is selected, there should be an associated county (variable 2). The combination of v2 and v3/4 should produce a result ... variable 5.

My question is when setting up tables, do I need to set up multiple county tables by county or do i make a master city table with county as a field? I'll need to use the county in a query so I didn't know if the list of cities needed to be pre-separated by county.

[ssanfu]

Duplicate post.
See https://www.accessforums.net/general...ack-29985.html

[XianSPL]

well that was helpful.

and it wasn't a duplicate post. i asked a very specific question in this post. one that could have been answered in probably the amount of time it took you to post your "reply".

[ssanfu]

Your first post was at 8:50AM. Your second post on the same topic was at 10:05am, (with a little more info). If you had posted again under the 8:50am post ,it would have been more helpful.

Yes, Access can probably do what you want. Without having more info on what you are trying to do, I would have the county in the same table as the Cities.

Good luck with your project...

[XianSPL]

My apologies for my harsh reply and I appreciate the feedback.