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.