many to many help?

[jellyroll12]

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, 2006 by Guest

[comment]

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