I'm having trouble with one to many and many to many relationships... I've tried creating a 3rd table keying off elements of two other tables. But I'm not getting any results (populated fields)

In a nutshell I've got a database that idenitifies Composites which are made up of Roles. Composites can have many Roles under them. The same Role can appear in multiple Composites. In addition there can be a number of transaction codes attached to a role.

Under "test" layout I was attempting to populate results. the issue I'm having is that multiple Transaction codes can belong to a Role. thanks to Ender I have relationship to define Composites and Roles but it stops at only one Transaction code per Role. It does not show other transaction codes within the role.

In this case Transaction code "AAAA" is attached to Role "AA_BB" but does not show up under Layout 5.

Any direction would be appreciated.

CompositeRolev6_copy_1.fp7.zip

Edited March 2, 200619 yr by Guest

Your serial ID's are in a state of confusion.