The problem with zipcodes is that there can be several cities referenced by the same zipcode. In other words the zipcode table (ZipCensus) does not have a unique value for each zipcode value--there are (in some cases) multiple records with the same zipcode value.
Also, some values may not appear in ZipCensus that need to be entered (i.e. Canadian or other foreign addresses).
Given the two tables listed below:
1) ZipCensus - containing the fields City, State, Zip, and other fields as well.
2) Customers - containing the fields City, State, Zip, and other fields as well. This is the table I want the values from ZipCensus (City, State) found by entering the zipcode in the Zip field in the Customers table.
-----------------------
I am looking to do all of the following:
1) If the zipcode value entered in ZipCensus is unique, the value of City and State from ZipCensus is entered as a default value in the Customers Table (Customers). And I want the data entry person to be able to modify this default if required without altering the ZipCensus values.
2) I want an acutal value in the Customers table for City, State and Zip rather than a value by Reference (not a merged compound form of two tables) This will allow entry of the customer's info as he/she wants it (some customers live in a special sub-division that have special "city" names for their subdivision - I want to honor their request in data entry too, even if it is not the official city name found in ZipCensus).
Also some values will be from foreign countries. I don't want these values to show up in the ZipCensus table. But entered exclusively in the Customers table.
3) If there is more than one value in the Zip table for the zipcode entered, then I want a list box (or form) to become visible to offer choices (the values for City and State found in ZipCensus that are associated with that zipcode). The User can select the choice she wants. The list box closes and the focus goes to the field after Zip (the next field name in the Customers table is Nickname).
I have very little database training (only had the first class this week - but I did read ahead in the text). My job requires me to develop this database now. So please be gentle with the jargon and explain how to do it thoroughly.
-- desperately at work on my knees praying for help
Also, some values may not appear in ZipCensus that need to be entered (i.e. Canadian or other foreign addresses).
Given the two tables listed below:
1) ZipCensus - containing the fields City, State, Zip, and other fields as well.
2) Customers - containing the fields City, State, Zip, and other fields as well. This is the table I want the values from ZipCensus (City, State) found by entering the zipcode in the Zip field in the Customers table.
-----------------------
I am looking to do all of the following:
1) If the zipcode value entered in ZipCensus is unique, the value of City and State from ZipCensus is entered as a default value in the Customers Table (Customers). And I want the data entry person to be able to modify this default if required without altering the ZipCensus values.
2) I want an acutal value in the Customers table for City, State and Zip rather than a value by Reference (not a merged compound form of two tables) This will allow entry of the customer's info as he/she wants it (some customers live in a special sub-division that have special "city" names for their subdivision - I want to honor their request in data entry too, even if it is not the official city name found in ZipCensus).
Also some values will be from foreign countries. I don't want these values to show up in the ZipCensus table. But entered exclusively in the Customers table.
3) If there is more than one value in the Zip table for the zipcode entered, then I want a list box (or form) to become visible to offer choices (the values for City and State found in ZipCensus that are associated with that zipcode). The User can select the choice she wants. The list box closes and the focus goes to the field after Zip (the next field name in the Customers table is Nickname).
I have very little database training (only had the first class this week - but I did read ahead in the text). My job requires me to develop this database now. So please be gentle with the jargon and explain how to do it thoroughly.
-- desperately at work on my knees praying for help
