Print Page | Close Window

ImplementingM2MRelationship.mdb (beginner)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=342
Printed Date: 28 Sep 2020 at 4:32am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: ImplementingM2MRelationship.mdb (beginner)
Posted By: Roger Carlson
Subject: ImplementingM2MRelationship.mdb (beginner)
Date Posted: 01 Aug 2008 at 3:59am

Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .
 

ImplementingM2MRelationship.mdb

This example illustrates two different methods of implementing in a form a Many-to-Many relationship that has been resolved by a linking table.

Method 1: Used in the instance where the data in the main tables is relatively static. This is used mostly for creating transactions in the linking table. It uses a Join of all three tables as the Record Source of the form. It is critical that the fields represented in the Join come from the linking table.

Method 2: Used in the instance where the data in the one table is dynamic and the other is relatively static. It is implemented as a 1:M between one main table and a Join of the linking table and the other main table. Pay close attention to which tables the join fields come from.
 
Download
Access 97 (81 KB):
http://www.rogersaccesslibrary.com/forum/uploads/5/ImplementingM2MRelationship97.zip - uploads/5/ImplementingM2MRelationship97.zip
Access 2000 (71 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/ImplementingM2MRelationship2k.zip - uploads/5/ImplementingM2MRelationship2k.zip



-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



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