Re: Newbie Question
Date: Thu, 31 Aug 2000 10:06:16 GMT
Message-ID: <8olamh$vhd$1_at_nnrp1.deja.com>
Hello
What you want to do is indeed very simple and much used when working with relational databases.
The best and easier way to do that is using LOVs. What the problems you got using this approach?
If you want to use listboxes, you can use a cursor
and the list item built-ins, as ADD_LIST_ELEMENT,
CLEAR_LIST etc, to add items dinamically to the
list. But have in mind if you have many hundreds of
cities, it can be muuuuch slower than using a static
LOV.
In article <R1Qq5.8356$bW2.92989_at_sodalite.nbnet.nb.ca>,
"Erin Peterson" <petersoe_at_bits.saintjohn.nbcc.nb.ca> wrote:
> Hi all.
>
> Having just started working with Oracle Forms 6 last week, this may
be a
> relatively simple question to answer. What I want to do is to take a
combo
> box that is on my form and instead of showing the actual DB values, I
want
> to show lookup values from another table. So, for example, instead of
> showing ID values from a city column in an address table I want to
show
> textual city names from a city table. Selecting a city from said
combo box
> would then store the appropriate value tied to the city name.
>
> I've done an LOV and that just doesn't do it for me. I want the user
to see
> and be able to select textual values.
>
> TIA for any answers (and your patience).
>
> Erin
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Aug 31 2000 - 12:06:16 CEST