| How to create LOV or record group? [message #622781] |
Fri, 29 August 2014 07:28 |
 |
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
|
Senior Member |
|
|
Hi all,
I have a LOV in ORDER column . Now the requirement is when I will double click or press F9 on SUPPLIER column the existing LOV should show . But condition is if that LOV returns single value then it should work as it is working today , but if that lov returns multiple value then it should show with SELECT ALL option . and When I select SELECT ALL option then all the values shows in LOV that should insert into the details block .
Please let me know how to do this and which trigger I should write the logic ?
I have an idea , but not sure how to proceed with this .
I can create one more RG or LOV which will have a hard code value SELECT ALL with the other values as below :
Select Select All from dual
UNION
Select distinct ORDER_NO from table1; .
So it will have all the values including Select all.
And in mouse double click I need to check , how many records the first (existing ) RG returning . If it is only one then use the default RG or use the above RG with Select All option .
Here If user select "SELECT ALL " then i need to write some logic .
Here I am not getting how to proceed ?
And also where I should write the logic .
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
