Prefilling fields based on other fields
This may sound elementary but I'm trying to figure out how to make certain fields populate based on other field's info. Such as: City= Nashville, then the County= Davidson.
There's more than one way to do that. See this thread for two different methods: Auto Fill
So I would need to make a table called "City" and in that table list the county and zip? I'm lost.
Your example does not have zipcodes used, it matches cities to counties. You'd need a table of records where each record is a different city and fields in it name the city and county. A relationship would then link your current table to this added table by the name of the city. The example in the forum thread shows two ways to use that relationship to get what you want. The best option will depend on how you need to work with this data and the pros and cons of each method are discussed in the thread.
Retrieving data ...