many to many relationships

[bpauley]

Hello All,
quick question that may lead to other questions.
Can you have more than one many-to-many relationships in one database?
If so, is there any direction or cautions that you can share?
If so, any good sites to visit to gain insight on how to properly handle?
OR is my table structure messed up?
Thanks
Bill

 

[John W. Vinson]

Hello All,
quick question that may lead to other questions.
Can you have more than one many-to-many relationships in one database?

Sure. Scores of them.

If so, is there any direction or cautions that you can share?

Simply understand how they work.

If so, any good sites to visit to gain insight on how to properly handle?

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

Crystal's chapter on Normalization would be apropos.

OR is my table structure messed up?

I don't have any idea since I can't see it from here.

 

[bpauley]

Thanks John,
I have been given the sites you sent before. I don't think I saw anything on
multiple m-t-m relationships, but I am heading back to review again. I want
to be sure I am getting the table structure and relationships correct before
continuing.
Thanks again
Bill

 

[John W. Vinson]

Thanks John,
I have been given the sites you sent before. I don't think I saw anything on
multiple m-t-m relationships, but I am heading back to review again. I want
to be sure I am getting the table structure and relationships correct before
continuing.

http://allenbrowne.com/bin/Access_Basics_Crystal_080220_Chapter_03.pdf

was the chapter I had in mind.