Re: Forms3 LOV

>
> SELECT 'Y', 'N'
> INTO :my_field
> FROM system.dual

Hmmm.... Try a UNION statement to get the two items as separate rows rather than as seperate columns.

Something like:

SELECT 'Y' FROM dual
UNION
SELECT 'N' FROM dual;

-- 

Bruce...        pihlab_at_hhcs.gov.au
                 ^^
*******************************************************************
* Bruce Pihlamae  --  Database Administration                     *
* Commonwealth Department of Health, Housing & Community Services *
* Canberra, Australia                             (W) 06-289-7056 *
*******************************************************************
* These are my own thoughts and opinions, few that I have.        *
*******************************************************************