Print Page | Close Window

Understanding many-to-many from a different angle

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Schapel, Steve
Forum Description: Steve Schapel's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=479
Printed Date: 28 Mar 2024 at 1:35pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: Understanding many-to-many from a different angle
Posted By: Steve Schapel
Subject: Understanding many-to-many from a different angle
Date 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 - http://accesstips.datamanagementsolutions.biz/many.htm



-------------
Steve Schapel
http://accesstips.datamanagementsolutions.biz/ - http://accesstips.datamanagementsolutions.biz/



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net