Relating 3 tables

[PeggyBall]

Hello,
I am new to Access and creating a database which includes personal information (name, address, phone, etc), officer position held and year, and awards earned and when. I have the following tables:

tblContact
Name
Address
Spouse
Email
Phone

tblAwards
AwardName (one row for each award - Merit, Excellence, etc)
AwardDescription
Year

tblOfficer
President
VicePresident
Secretary
Treasurer
Current (yes/no)
Year

Each person can earn more than one award and serve in more than one office. I want to link the tables (or should it really be one table rather than 3) and print a report showing current officers, past officers and when each person received an award.

I appreciate any help!

 

[PHV]

Have a look here:

http://r937.com/relational.html

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[johnherman]

tblContacts looks OK

tblAwards looks OK

tblOfficer
OfficeTitle (President, etc)

tblContactAward
ContactName (key to tblContacts) *
AwardName (key to tblAwards) *
DateOfAward *

The * fields constitute your primary key. Alternately, you can add an identifier ContactAwardID to be the unique key.

tblContactOfficer
ContactName *
OfficeTitle *
OfficeHeldStartDate *
OfficeHeldEndDate

Again, the * fields constitute your primary key. Alternatively, you can also add an identifier as above.

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

 

[PeggyBall]

Thank you for the help