| 
		
			| 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
 |  
	|  |  |