One Resource for ALL

[Jscott]

What if you have multiple Tables that are all related and you want to use a Zip Code table as a resource for all? How do you accomplish this without creating multiple occurrences in the Table Base?

[Lee Smith]

You can use separate relationships to accommodate different files.

It isn't clear to me whether if you are going to maintain this information in a separate file, or just a TO, however if you plan on packaging some of these files as separate solutions, you will need to remember to include a copy of it.

HTH

Lee

[mr_vodka]

You can create a 'X' operator, cartesian join. Then you can use the table for reference purposes since it will display all the records. You would still have to create the relationship in various spots where you need it though. Unless it is across valid related data sets, in which case you could use that relationship across the tables.

[Jscott]

Lee, it is not a seperate File. Cartesian Join? I lost you Vodka. I have 12 Tables that ask for different addresses for different people. All 12 Tables are related to each other. I can easily relate the Zip Code Table to any 1 of the 12, but what I want is simply for all 12 tables (City, State) to do a look up from the Zip table when a Zipcode is entered into an address field.

Make Sense?

[Lee Smith]

I don't understand why you have 12 tables of names and addresses, can you post a copy of your file?

[mr_vodka]

It makes more sense to have all your addresses in one central table that you could reference. As Lee pointed out, what is your purpose of having 12 different tables storing addresses?

[Jscott]

I have a Primary Table that contains data on a single person. I have 2 other Tables (Dentists & Physicians) so that if the person has 40 Dentists and 60 Physicians, I can manage that data easier. Thus the reason why I do not have all of the addresses in a single Table.

[Lee Smith]

I only see three tables needing relationships in your description.

[Jscott]

I was trying to keep it simple.

If I can make it work for 3, I can make it work for 12.

Thanks

[Ender]

I can easily relate the Zip Code Table to any 1 of the 12, but what I want is simply for all 12 tables (City, State) to do a look up from the Zip table when a Zipcode is entered into an address field.

Use a different table occurrence of the Zipcode table for each lookup. Name them so you can tell them apart (Zipcode by Contact, Zipcode by Dentist, etc.).