I have a client table and a zip code table. The client table has the following fields:

residential zip code, residential city, residential state, business city, business state and business zip code. The fields are used to allow both residential and business info. for each client.

The zip code table contain zip code, city and state fields obviously. My problem is that when I create a relationship between the zip code fields of each table and try to create a lookup for the residential city, state fields that also changes the business city and state fields, obviously.

How can I create separate lookups for both business and residential fields using one zip code table.

Use two TOs (table occurences) of the Zip Code table, one related to the Residential Zip Code, and the other related to the Business Zip Code. Then each set of City/State fields can use their respective relationships to pull the right info.

You are the man. thanks.