>>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

The problem with using the QBF control that ships with the product is that it uses a filter and in most cases will not be very fast. I recommend getting a framework to do these kinds of things. They will be much faster and you will spend much less time doing the mundane things, freeing you to concentrate on more specific problems.


My personal choice is VFE from f1tech.com