many to many relationships

  • Thread starter Thread starter bpauley
  • Start date Start date
B

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
 
Hello All,
quick question that may lead to other questions.
Can you have more than one many-to-many relationships in one database?
Click to expand...

Sure. Scores of them.
If so, is there any direction or cautions that you can share?
Click to expand...

Simply understand how they work.
If so, any good sites to visit to gain insight on how to properly handle?
Click to expand...

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?
Click to expand...

I don't have any idea since I can't see it from here.
 
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
 
Back
Top