Avatar of Mark Wood
Mark WoodFlag for United States of America

asked on 

Access DB Help

I have an Access database which has 3 tables, 1 for members, 1 for committees, and 1 for positions.

How do I create a relationship that will collect data from all 3 tables.

I am new to access and trying to figure out how to create these relationships so they work and allow me to enter the data into the db.

A member may or may not belong to a committee or they may belong to many committees. If they do belong to a committee they will hold a position.

I have attached the db if it will help.
Microsoft Access

Avatar of undefined
Last Comment
Mark Wood
Avatar of Missus Miss_Sellaneus
Missus Miss_Sellaneus
Flag of United States of America image

Don't have Access installed so I can't look at the DB, but if I understand your structure you should have a fourth table to tie them together with 3 fields, memberID, positionID and committeeID. You could include other fields such as joindate and exitdate to keep a history.
Avatar of Mark Wood
Mark Wood
Flag of United States of America image


I can create the table .. no problem. not sure how to do the relationship correctly. (what to what)
Each of the three tables you described will have an ID field and the 4th table ties them all together.

So, say your 3 main tables are committee, position and member.

example structures:
committee (committeeID, committee_name,committee_purpose)
position (positionID, position_name)
member (memberID, member_name)
memberhistory (memberID, committeeID, positionID, start_date, end_date)

Each record in the memberhistory table shows one member's position in one committee.

memberhistory.memberID = member.memberID
memberhistory.committeeID = committee.committeeID
Avatar of PatHartman
Flag of United States of America image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Mark Wood
Mark Wood
Flag of United States of America image


Thnk You
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo