APEX

Hi,

I have a select list and based on a user's choice form the select list with submit and I need to populate a list manager.

So in the LOV for list manager, I have something like this

select name display_value, id return_value
from ORGANIZATION
where code =:my_item and color='G'

I couldn't even APPLY CHANGES, I get

1 error has occurred

* LOV query is invalid, a display and a return value are needed, the column names need to be different. If your query contains an in-line query, the first FROM clause in the SQL statement must not belong to the in-line query.

Please advise.

Thanks.