|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 6th, 2007, 06:56 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
USE ONE FIELD TO FILL IN OTHERS
I DOWNLOADED THE ZIP CODE DATABASE WHICH HAS THE CITY AND STATE FOR THE ZIP
CODE PROVIDED. (SEPERATE TABLE) I HAVE ANOTHER TABLE, CUSTOMER INFO IN CUSOTME RINFO TABLE I HAVE A FIELDS CALLED ZIP, CITY, STATE, ETC... I WOULD LIKE IT FOR IT TO RECOGNIZE WHEN I ENTER THE ZIP CODE (RELATIONSHIP BETWEEN ZIP FIELD AND THE ZIP DATABASE) (DROP DOWN OR ENTER (PERFERABLY SEARCH BY CITY...? ) FOR IT TO AUTO FILL IN THE CITY AND STATE, AND NOT ALOW MISMATCHED CITY. SO YOU CANT ENTER 02886 FOR SEEKONK, WHEN IT IS ACTUALLY WARWICK. 
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
