Home » Developer & Programmer » Forms » I want to populate only particular employee LOV
I want to populate only particular employee LOV [message #581035] Mon, 01 April 2013 02:20 Go to next message
mist598
Messages: 1059
Registered: February 2013
Location: Hyderabad
Senior Member
Hello sir,

I want to populate only particular employee LOV ,when i am press "Populate LOV"
Button and i attached Form for testing and It is a 10g version...

Thanks,
  • Attachment: XX_LOV.fmb
    (Size: 128.00KB, Downloaded 44 times)
Re: I want to populate only particular employee LOV [message #581047 is a reply to message #581035] Mon, 01 April 2013 05:31 Go to previous messageGo to next message
Littlefoot
Messages: 19889
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't have Forms so I can't look at your form.

LoV is attached to an item, it populates an item in a single record (so you can't populate several employees anyway). Therefore, what does "populating only particular employee LOV" mean? What is a "particular employee LOV"?
deptno in the deptno text box ,jobs list show the jobs corresponding to the deptno i entered [message #581193 is a reply to message #581035] Wed, 03 April 2013 03:21 Go to previous messageGo to next message
mist598
Messages: 1059
Registered: February 2013
Location: Hyderabad
Senior Member
hello everybody,,


i have 2 items which are retrieved from a single block employees.
1.deptno text item
2.jobs text item but its converted to list box


what i have to achieve is that while entering deptno in the deptno text box ,jobs list show the jobs corresponding to the deptno i entered. i created a trigger n tried with some queries.
which smart trigger i have to create ??
how i have to perform the code??

Thanks..
Re: deptno in the deptno text box ,jobs list show the jobs corresponding to the deptno i entered [message #581203 is a reply to message #581193] Wed, 03 April 2013 05:46 Go to previous messageGo to next message
cookiemonster
Messages: 11285
Registered: September 2008
Location: Rainy Manchester
Senior Member
Don't do that. Use a text item with an LOV instead.
If you use a list item then you won't be able to query records where the job doesn't match one in the current set in the list item.
Re: deptno in the deptno text box ,jobs list show the jobs corresponding to the deptno i entered [message #581250 is a reply to message #581203] Wed, 03 April 2013 13:35 Go to previous messageGo to next message
Littlefoot
Messages: 19889
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Here's how I do that; as Cookiemonster says, use list of values (which means: leave JOBS as a text item).
- create a record group which selects jobs depending on DEPTNO:
select distinct job
from emp
where deptno = :your_block.deptno_text_item
order by job

- create a list of values which is based on previously created record group
- run a form
- enter department number and navigate to JOBS item
- open list of values (check which key is mapped to it, or - simply use a toolbar button)
- select a job from the list of values

As you can see, you don't need any trigger.
Re: I want to populate only particular employee LOV [message #581272 is a reply to message #581035] Thu, 04 April 2013 00:49 Go to previous message
mist598
Messages: 1059
Registered: February 2013
Location: Hyderabad
Senior Member
Thanks!
Previous Topic: R12 form customization (content canvas with tab canvas and 2 stacked canvas)
Next Topic: Form
Goto Forum:
  


Current Time: Fri Dec 19 19:15:10 CST 2014

Total time taken to generate the page: 0.09621 seconds