LOV population: [message #83777] |
Wed, 10 December 2003 22:23 |
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 |
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
|
|
|