Re: lookup combo boxes

I'm not sure how much help I'll be, but I'll let you know what I've found out.

At least in Oracle Forms, you can base a LOV on a record. You can have this record contain a select statement. Therefore, if you had the record be:

SELECT fielda,
fieldb,
fieldc
FROM this_table;

you could set the LOV to use this record and choose all 3 fields at once (the LOV should display all 3 fields. if it doesn't, adjust the width). Then when you select a row in the LOV, it will populate all related fields (you need to set the column mapping property of your LOV...assign a destination for each field you are using).

Like I said, I'm not sure how this works for the web stuff. I've never dealt with that. But this is how it works for Forms at least. Maybe this will at least give you somewhere to start looking in the documentation and/or online help.

Best of luck!
KRM In article <14978418.840257da_at_usw-ex0110-075.remarq.com>,   Oraconfused <ehuntNOehSPAM_at_cyberrange.com.invalid> wrote:
> Is WebDB capable of having combo boxes that when you choose
> an item from that combo box, the form finds the record and
> desplays the rest of the customers information on the form.
> Instead of just having a LOV where one field is filled in
> and you have to add the rest. This would be equivalent to a
> lookup form in MS Access.. any ideas?
>
> * Sent from AltaVista http://www.altavista.com Where you can also
find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 08 2000 - 18:06:44 CET