Question about database design

[xandre]

I'm a beginner. Our current database has two tables that pertain to contacts. One has records that list the principal, athletic directors and school address. One table has superintendants and their addresses. The problem is that I can't print labels for all of these contacts at once. I think it's because the principals and athletic directors are in one table and 'share' an address. Is there a way around this, or is it necessary for each name to have it's own address?


Dawn

 

[LarryDeLaruelle]

Dawn:

Given what you describe, proper design would have one table for contacts (ContactID, Name, Title, etc) and one table for School (SchoolID, School name, address, etc).

The table for contacts would also have a field for SchoolID that would link to the table for schools.

This design would allow you to query by Title and select the combination of recipients that you need.
Larry De Laruelle
larry1de@yahoo.com

 

[dneufarth]

You might try a "make table" query to get the superintendants into a temp table and then follow this up with two "append" queries to add the principals and atheletic directors to the temp table. Once completed the temp table will have all three titles and can be used as a source for mail/merge or a report.

Dave

 

[TheInsider]

Or try a Union query Rob Marriott
rob@career-connections.net