Custom AutoSearch with multiple sub-searches

rbuser

RBuilder version: Enterprise 6.03
Delphi environment: D5, D7

We have created several custom autosearch forms in the past, but they
typically filter a field (such as CustomerID) on one criteria at a time.
For example, an existing custom autosearch on CustomerID can filter on
Customer Name OR Geographic Region OR State, etc..

We have an application that has a 'customer search' form, which includes
comboboxes for all of the relevant, searchable fields in our customer table
(CustomerID,SalesManagerID,StateID, etc.). We would like to create a
similar form that would popup as part of the AutoSearch form when we select
on CustomerID as AutoSearch in the End User Reporting tool. We know how to
create a custom AutoSearch form that would 'embed' Customer Search form into
the standard AutoSearch form, but we're not sure how we would add multiple
search criteria in AutoSearch based on the user's selections from our
CustomerSearch form.

Example: In custom AutoSearch form, user selects:
CusomerSalesManagerID = 123,
CustomerState = 'NY',
etc.
(Keep in mind this is based on a single AutoSearch field of CustomerID.)

Any ideas or examples would be greatly appreciated.
Thanks in advance.

digitalmetaphors

Here is the only tip project we have that provides dynamic lookup search
criteria displayed on the form for different selected search criteria.

http://www.digital-metaphors.com/tips/CustomAutosearchDialog.zip


Cheers,

Jim Bennett
Digital Metaphors