Jump to content

Creating lookups for both my business and residential fields


shawnj985

This topic is 6452 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6452 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.