Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Custom AutoSearch with multiple sub-searches

edited February 2003 in End User
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.

Comments

This discussion has been closed.