USE ONE FIELD TO FILL IN OTHERS

J

Jarred

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search on one field & fill in the correct matching record 2
How to use matching values in two worksheets to return another value 5
Designing a patient management 4
ZipCode Lookup and field fill 8
Text to column using multiple spaces?? CITY STATE ZIP 2
Lookup to show on form 7
redundant data - help with Contact Database 6
Drop Down that returns value in same table 5

Top