Re: Designer2000 - GUI items

Reinhard Bergander <100330.2165_at_CompuServe.COM> wrote:

>Designer2000, Database items displayed as GUI items
>
>I have the same old problem:
>
>- There is a table with a foreign key (number) to a lookup table
>- I don't want to display a LOV, but a listbox (there are only a
>few values
> in the lookup table) with the meaning of the FK
>- I checked the SoftLOV, marked the "denormalized..table"
> and "denormalize..column"
>- I did an update to the CG_REF_CODES tables
>- I tried to generate it
>
>..but it doesn't work !
>
>The Oracle hotline told me, that's not possible to do this !!
>

Your message isn't completely clear. Is your FK to a lookup table or does it have "valid values" defined for it? Or both?

If its a lookup (e.g. *no* valid values defined), then you need to check the LOV settings for the desired columns in the LOOKUP DTU (and unset LOV in the base DTU). If its a column with valid values, then you pick LIST BOX (meaning).

>(By the way, using the Forms Designer manually, it's easy to do
>this: Creating a record group, Populating it, and poulating the
>Listbox from the record group)
>Any ideas ? Is it true ? :-(
>
>Thanx in advance,
>
>reinhard
>
>--
>-------------------------------------------------
>KLINIK OP-DATA Software GmbH
>Phone 0049-(0)941-59208-10 Fax -20
>-------------------------------------------------

-JJ

 Jeffrey Jacobs & Associates
 Oracle Designer/2000 Consulting & Training  951-2 Old Country Road, Suite 119, Belmont, CA 94002  Voice: 415-571-7092, FAX: 800-665-1379 CompuServe: 76702,456  Internet: 76702.456_at_compuserve.com     Received on Thu Mar 21 1996 - 00:00:00 CET