Auto Populate based on another table

[Viper210]

Thanks in advance to anyone who can help.

The intent of my database is to collect collect as efficiently as possible information from a client and be able to autopopulate as much information as I can such as County, City, and zip code. So far, I have a table called intake which is the main table for my database.

Secondly, I have a table callewd Counties that contains the 4 counties that I have autopopulating the Intake table via a lookup field.

I also have 4 other tables that contain all the city and zips for each of the 4 Counties. Here is where I am having the problem. How do I llink the city/zip table to the specific county table so that I can only see (via a lookup) and autopopulate the city and zip for the appropriate County?

 

[Viper210]

I appreciate the response. What I meant to say is that I want to be able to have city and zip as lookups where I can then select them in my table or form.

The problem is I don't know how to link the cityzip table to the County selection in the main table which is also a lookup. Any suggestions?