May 27, 200421 yr 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
May 28, 200421 yr You need to select the address from the Co-Broker table, not just Broker. Have you done that?
Create an account or sign in to comment