I am using Visual FoxPro 5.0 and Crystal Reports 5.0, I have selected (Filtered) Records which I want to pass to Crystal reports thru CR OCX, I am able to do it by passing the command

thisform.cyrstal1.object.sqlquery = "Blah Blah"

it works fine when the report and the queried list I want is restricted upto single table,

But gets messy when it is related with multiple table by relationship..

Am I using the right way...? Or can any one suggest me to get rid of this thing as such it is very important for me.... to give the reports of Queried (Filtered) List..

Thanks and Regards