>>A client has asked for a Query-by-Form procedure "Just like the one I use in FileMaker". I can take my basic data-entry forms for each of her tables and make a SQL-Select statement with any fields she fills in with data. However, I thought one of you brilliant and knowledgable (and of course good-looking, charming and kind to small animals) members would know of a 3rd party add on I could use or some other faster method.
>>
>>Any suggestions?
>>TIA
>>
>>Barbara
>
>You mean some sort of Query-Designer?
Not quite, Alexandre. She wants a form that LOOKS like her data-entry form, but she will only fill in the fields she wants to search on. For instance she could put < {01/01/97} in a date field and %SMITH% in a text field. Then the program would write a SQL select which would include
WHERE ThisDate < {01/01/97} AND 'SMITH' $ ThisText
in the SQL. Not easy to set up, since it has to include all of the wild-card actions. She already has QueryMaker, and uses it constantly, but is looking for quick filters to use on the actual data entry forms.
Barbara