Home » Developer & Programmer » Forms » LOV population:
LOV population: [message #83777] Wed, 10 December 2003 22:23 Go to next message
Pooja S
Messages: 1
Registered: December 2003
Junior Member
LOV population:

Depending on ceratain condition i want to change the query of the LOV. How can I do it at run time?
For Eg: I create a LOV and assign a query 'Select ename from emp where dept = 10'.

Now based on a condition I want to change the query to 'Select ename from emp where dept in (10,20,30)'
Should I have to use 2 seperate LOVs or can I achieve it with one LOV. Kindly explain with code.
Re: LOV population: [message #83789 is a reply to message #83777] Fri, 12 December 2003 02:33 Go to previous message
magnetic
Messages: 324
Registered: January 2003
Senior Member
sorry i got no code just right now but you should use 1 lov and base this on a recordgroup, wich should be dynamically changed.
forms help should contain an example of a dynamic poplist/lov
Previous Topic: Icon is not dispalying in button
Next Topic: Coordinating Blocks
Goto Forum:
  


Current Time: Wed Apr 24 23:36:45 CDT 2024