Practical Poorly Educated Many to Many Question - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Practical Poorly Educated Many to Many Question

James Chessher

2 hours ago

I am asking for clarity and opinion. I have an unavoidable situation where Table ("B") will have a single record which could require up to 700 join connections to Table ("C") Records. Exacerbating this, there could easily be 500 Records from Table ("B") doing the same thing. Is this something, in your opinion Access can easily handle when Reports are needed to be generated? Do I just not grasp the full capability of Access?

	James Chessher OP @Reply 2 hours ago

Thomas Gonder @Reply

98 minutes ago

Overlooking your incorrect terminology, although there are many ways to say it correctly:
I think you want to say you have a one-to-many A to B relationship.
And a one-to-many C to B relationship.
Table A and C have a primary key.
B will contain one primary ID unrelated to A or C.
B will have two foreign keys, one for A and one for C.
With all of that you have a classic many-to-many relationship.
B is a "Junction" table.

Access will handle your situation well into the hundreds of thousands of records.
Richard has a "Relationships" video which explains this quite well using drivers and cars.
https://599cd.com/blog/display-article.asp?ID=1724

Next Unseen

New Feature: Comment Live View