2 Lovs [message #409298] |
Mon, 22 June 2009 01:21 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Can i put 2 search finds in one lov which has 2 items item code and name
|
|
|
|
|
|
|
|
|
|
Re: 2 Lovs [message #409552 is a reply to message #409548] |
Tue, 23 June 2009 01:50 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
David its very simple i have two fields in lov item_code,item_name all i want is a "find" search on these two fields . i must have the facility to put item_code% or item_name% depending upon the radio button chosen or some other logic what you feel best.
|
|
|
|
|
Re: 2 Lovs [message #409569 is a reply to message #409557] |
Tue, 23 June 2009 02:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
thanks david , but please give me any sample form with this idea.or if you can do that and give it to me as i am not that familiar to forms 6i.
|
|
|
Re: 2 Lovs [message #409751 is a reply to message #409559] |
Tue, 23 June 2009 19:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/67467.jpg) |
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
@VamsiKrishna,
To have a different sort order based on a radio button do the following. Have two record_groups with the same 'select' but with a different sort sequence. In the 'show_lov' trigger of the item in question, use the value in the radio item to invoke a 'set_lov_property('lov_name', GROUP_NAME, 'rec_grp_name');' command which associates one or other of the record_groups to the LOV.
David
|
|
|