>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 applacation. I hope my message is not to long for this system, But I really need help understanding.
>
>Please Help
>Thanks


John,

There is a Query-by-Example form in the samples section of VFP6.0 that should get you started. Combining this
with Nick's suggestion to build an SQL (the sample uses a filter) should do the trick.

Ken