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.