City, State Zip lookup

[garywmcp]

I want to be able to fill in the City, State and Zip Code fields in my customer and employee table from my zipcode table.

I see how I can do a multiple lookup from the zipcode table, however, I don't see how I can use the three columns of data from zipcode table to complete and fill in the same three fields in the customer or employee table.

As a note, I'm constructing a web data base that will be hosted on a sharepoint hosting site.

Here are my fields in both tables:



zipcode table:
ID
zip_code
city
state_prefix
county
locationtext
location

customer table:
first_name
last_name
address1
address2
city
state_prefix
zip_code
home_phone
mobile_phone

Can I use the Lookup & Relationship wizard (I suspect not) or do I need to construct a macro from a query, etc.

Appreciate the advise

[pbaldy]

Does this work for you?

http://www.baldyweb.com/Autofill.htm