how to bind 2 details and relastion in subreport？

RickyHuang · Post by **RickyHuang** » Tue Feb 23, 2010 10:02 pm

I have 3 Table
1.OrderMaster
2.OrderDetail
3.Employee

report：
Master Report-OrderMaster Info
SubReport1-OrderDetail List
SubReport2-Empoyee Info

relation：
OrderMaster's OrderID-OrderDetail's OrderID
OrderMaster's EmployeeID-Employee's EmployeeID

SubReport1's relation can work,but SubReport2 doesn't

please tell me how to do it...

attach this VB Project
http://filesky.com/publish/24/61.aspx

Another exampler:
products will need a lot of suppliers and will be distributed to many different customers
I need a form with the function to list down all the suppliers and clients
Thank you...

Post by **Edward** » Wed Feb 24, 2010 8:09 pm

Hi

Please right-click in the report designer on relations 'MasterDetail' and 'MDEmployee'. Change NameInSource parameter as 'Relation1' and 'Relation2' accordingly. That relation names can not have the same name.

Thank you.

RickyHuang · Post by **RickyHuang** » Thu Feb 25, 2010 12:22 am

oh...it can work

thanks for your help

Post by **Andrew** » Thu Feb 25, 2010 5:22 am

We are glad to help you.

Thank you.