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.
attendance.accdb
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.
attendance.accdb
Last Comment
Missus Miss_Sellaneus
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.
ASKER
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_p
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.
so:
memberhistory.memberID = member.memberID
memberhistory.committeeID = committee.committeeID
memberhistory.positionID=p
So, say your 3 main tables are committee, position and member.
example structures:
committee (committeeID, committee_name,committee_p
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.
so:
memberhistory.memberID = member.memberID
memberhistory.committeeID = committee.committeeID
memberhistory.positionID=p
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
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.
ASKER
Thnk You
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.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
