>I'm new to VFP6.0a, but have a Dbase3 backround. My problem is that I'm trying to create a search form that will allow the user to input to the search form (which requires access to two different databases)and have the results set the condations for the output report. The current form has four text box's (text1, text2, text3 and text4)The two databases are client and payment. The first field is Client.Group Dode, the second is payment is Payment.InsCompany the final two are Payment.startdate, and Payment.enddate. The report form is caled rpt1.
>I beleive that once I see an example of the code I be able to relate it to my application. I hope my message is not to long for this system, But I really need help understanding.
>
>Please Help
>Thanks

John, based on user input in textboxes you may build the SQL statement and create report cursor.

Something like:

SELECT client.field1, client.field2, payment.field1, payment.field2 ;
FROM client, payment ;
WHERE client.field1 = lcClientGroupCode_from_textbox1_value ;
AND payment.field2 = lcPaymentInsCompany_from_textbox2_value ;
...
INTO cursor myreportcursor

HTH,

Nick