OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » 2 Lovs (Forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

2 Lovs [message #409298]

Mon, 22 June 2009 01:21

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

Can i put 2 search finds in one lov which has 2 items item code and name

Report message to a moderator

Re: 2 Lovs [message #409304 is a reply to message #409298]

Mon, 22 June 2009 01:43

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

I don't think so.
But why do you need it?

By
Vamsi

Report message to a moderator

Re: 2 Lovs [message #409311 is a reply to message #409304]

Mon, 22 June 2009 02:09

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

Just to make the search simpler.can we put a condition like radio button upon choosing we can search..

Report message to a moderator

Re: 2 Lovs [message #409318 is a reply to message #409311]

Mon, 22 June 2009 02:31

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Yes.
Depending on the radio button value, you can dynamically change the lov for that field.

By
Vamsi

Report message to a moderator

Re: 2 Lovs [message #409319 is a reply to message #409318]

Mon, 22 June 2009 02:38

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

yes but do you have any samples or u can send me some sample fmb having this functionality.

Report message to a moderator

Re: 2 Lovs [message #409532 is a reply to message #409319]

Tue, 23 June 2009 01:15

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Just use one record_group and two LOVs. One for each item.

David

Report message to a moderator

Re: 2 Lovs [message #409534 is a reply to message #409532]

Tue, 23 June 2009 01:22

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

thanks david but you misunderstood me , i want 2 finds (search criterias) in one lov.

Report message to a moderator

Re: 2 Lovs [message #409548 is a reply to message #409534]

Tue, 23 June 2009 01:36

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

How will the user determine which search criteria to use?

David

Report message to a moderator

Re: 2 Lovs [message #409552 is a reply to message #409548]

Tue, 23 June 2009 01:50

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

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.

Report message to a moderator

Re: 2 Lovs [message #409557 is a reply to message #409552]

Tue, 23 June 2009 02:02

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Then have a record_group based on item_code and item_name and depending on which item has the focus when the LOV is invoked change the sort sequence and display the LOV for that item.

David

Report message to a moderator

Re: 2 Lovs [message #409559 is a reply to message #409552]

Tue, 23 June 2009 02:03

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

I totally misunderstood the original post.
What I understood is:
You have two lov's and want to attach one of them to the item field depending on the radio button, which user has selected.

By
Vamsi

Report message to a moderator

Re: 2 Lovs [message #409569 is a reply to message #409557]

Tue, 23 June 2009 02:35

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

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.

Report message to a moderator

Re: 2 Lovs [message #409751 is a reply to message #409559]

Tue, 23 June 2009 19:53

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

Report message to a moderator

Previous Topic:	Forms to call php file to output csv result
Next Topic:	problem for export to excel functionality-unable to compile the form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:31:53 CDT 2024