ImplementingM2MRelationship.mdb (beginner) |
Post Reply |
Author | |
Roger Carlson
Microsoft MVP Joined: 20 Feb 2008 Status: Offline Points: 261 |
Post Options
Thanks(0)
Posted: 01 Aug 2008 at 3:59am |
Please consider donating $1 per sample downloaded, 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. |
|
|
|
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 |