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

>
Want a good read? Try The Summer of His Life (available on Amazon!)

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
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.