Understanding many-to-many from a different angle |
Post Reply |
Author | |
Steve Schapel
Microsoft MVP Joined: 04 Jul 2009 Status: Offline Points: 10 |
Post Options
Thanks(0)
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 |
|
Steve Schapel
http://accesstips.datamanagementsolutions.biz/ |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |