APEX

Hi folks,
I have one challange. I have a search engine and there is an popup lov and its having three Display and 3 Retun value such as

select
p.A || ', ' || pi.B|| ', ' || km.C|| ' ' d, p.A || ', ' || pi.B|| ', ' || km.C|| ' ' r
from tableA km,tableB p,tableC pi
where km.col1=p.id and km.col1=pi.id and km.C is not null

when i click on the pop lov it will display 3 values shuch as SAP+DBA+HR and in popup lov iteam its will return 3 values
such as SAP+DBA+HR this return values are from 3 cloumn names from same table ie. A column, B column, C column
and when i click on submit button this return values from 3 columns values should assign to the 3 column such as
A=SAP, B=DBA and C=HR and search fetchs the result in a Report.

Its some thing new, is it possible..:)

ok will be waiting for your reply..:D

Regards,
Suri

Edited by: user634694 on Feb 25, 2009 3:14 AM