I want to be able to have a "Zip Code" table that has city, state and county information connected to the Zip Code that will be the primary key. I used to use Paradox years ago, and they had a feature where you could use "fill-in" forms and I used that to fill in the city/state/county info by keying in the zip code. How does one do this in access? Look-up tables aren't what I want to do, as it is limited to one column, or so it seems to me.
Any ideas. Thanks in advance.