Re: Designer2000 - GUI items

On 21 Mar 1996 13:36:45 GMT, 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 !!
>
>(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
>-------------------------------------------------

Yes, they are all right, you can not use GUI items in that way you will - instead LOV in PK->FK relation.
The only way to deploy GUI-Items is to bind column with the domain with allowable values or define this values on the item level directly.
With the check box SOFT-LOV ( on column or domain level ) you can decide if you want the static ( values hard coded in Forms ) or dynamic ( populated with record group from CG_REF_CODES ) GUI-Items ( applicable only for pop-list and combo-boxes )

hope this helps

jacek Received on Fri Mar 22 1996 - 00:00:00 CET