>I am setting up a means to search for the following information:
>
>Last Name (in Customers table)
>License Plate (Orders Table)
>Vehicle ID Number (Orders Table)
>Order Number (Orders Table)
>
>My concern is "How do I search by "Last Name" if it is actually in the CUSTOMERS table, which is related to the ORDERS table?
>
>I could over-program this, but I wonder if anyone else has run into this situation?
>
>I was thinking about making a View that would handle this. Is there another way?
>
>Cecil
When I was developing a search form a while ago, I used CursorAdapter and set SelectCmd dynamically on the fly. In SQL Server this is one of the most commonly asked questions and the advice is usually to go with the dynamic SQL. Same thing applies to the searches from VFP - you construct the select dynamically by checking which parameters are set in the form.
If it's not broken, fix it until it is.
My Blog