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

Own dropdowns

edited March 2007 in End User
Hi

My RB end user environment uses views, no tables.
The views contain both the id and the description for some fields.
Example : COUNTRY_ID and COUNTRY

The user may select "i want all customers from holland"

Now they have to fill in "holland"

I want the query to be :

select * from customers where country_id = 25

instead of

select * from customers where country = "Holland"

the one with the id is much faster.

So i want to give the users a dropdown with country selection and let fill
in the ID in the query.

Is this possible and if so is there an example?

Eric

Comments

  • edited March 2007

    - check out RBuilder\Demos\AutoSearch\Custom AutoSearch Dialog

    - as shown in the example you can create a custom AutoSearchDialog class and
    custom AutoSearchPanel classes. You AutoSearchDialog can contain logic to
    determine which autoseachpanels are used for specific datafields.

    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.