OraFAQ Forum: Forms » I want to populate only particular employee LOV

Home » Developer & Programmer » Forms » I want to populate only particular employee LOV

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

I want to populate only particular employee LOV [message #581035]

Mon, 01 April 2013 02:20

mist598
Messages: 1195
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 1035 times)

Report message to a moderator

Re: I want to populate only particular employee LOV [message #581047 is a reply to message #581035]

Mon, 01 April 2013 05:31

Littlefoot
Messages: 21808
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"?

Report message to a moderator

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

mist598
Messages: 1195
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..

Report message to a moderator

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

cookiemonster
Messages: 13920
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.

Report message to a moderator

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

Littlefoot
Messages: 21808
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.

Report message to a moderator

Re: I want to populate only particular employee LOV [message #581272 is a reply to message #581035]

Thu, 04 April 2013 00:49

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Thanks!

Report message to a moderator

Previous Topic:	R12 form customization (content canvas with tab canvas and 2 stacked canvas)
Next Topic:	Form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 17:23:19 CDT 2024