Help with a Dual Relationship off of one Table

[Joseph31]

Hello everyone...

Here we go..

The setup:

I have two tables called "Policies" and "Brokers"

In the policy table I have a drop down field that list all of the brokers in the Broker table...

Now I have a report that I have made that puts on the correct broker with there address from the associated table.

all of this works...

My problem comes from when I have another field on the policies table called Co-brokers...This also has a list; listing all of the same brokers from the same table as the first.

On the same report that I did above...I try to get it to list the correct address with the cobroker that I have selected but all it lists is the first brokers information...

How can I get it to list seperate information from the same table...

Thank you

[The Shadow]

You need to select the address from the Co-Broker table, not just Broker. Have you done that?

[Joseph31]

Got it thanks.....

Joseph