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