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.
Printed Date: 28 Sep 2020 at 4:32am
Software Version: Web Wiz Forums 12.03 -

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, - find out why here .


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.
Access 97 (81 KB): - uploads/5/
Access 2000 (71 KB): - uploads/5/

Consider donating $1 per sample downloaded," rel="nofollow - find out why here .<

Print Page | Close Window

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