Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Schapel, Steve
  New Posts New Posts RSS Feed - Understanding many-to-many from a different angle
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

Understanding many-to-many from a different angle

 Post Reply Post Reply
Author
Message
Steve Schapel View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 04 Jul 2009
Status: Offline
Points: 10
Post Options Post Options   Thanks (0) Thanks(0)   Quote Steve Schapel Quote  Post ReplyReply Direct Link To This Post Topic: Understanding many-to-many from a different angle
    Posted: 04 Jul 2009 at 12:30pm

Many-to-many relationships

In real-life situations, elements of information are often in a many-to-many relationship with each other.  An Employee can work on a number of Projects, and a Project can be worked on by a number of Employees.  A Member can borrow a number of Books from a library, and a Book can be borrowed by a number of Members.  A Student can enrol in a number of Courses, and a Course can have a number of Students enrolled.

However, when trying to model this information into a relational database structure, Access doesn't allow us to directly establish a many-to-many relationship between 2 Tables...

Read more here: http://accesstips.datamanagementsolutions.biz/many.htm

Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down