OraFAQ Forum: Forms » HOW TO ATTACH LIST ITEM VALUE BASED ON ANOTHER LIST ITEM

Home » Developer & Programmer » Forms » HOW TO ATTACH LIST ITEM VALUE BASED ON ANOTHER LIST ITEM (FORMS6I)

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

HOW TO ATTACH LIST ITEM VALUE BASED ON ANOTHER LIST ITEM [message #305346]

Mon, 10 March 2008 08:49

karunakar_adepu84
Messages: 43
Registered: January 2008

Member

HI THIS IS Karna here,
I have a small doubt about list item,
here is my Q:

I have a list item name with deptno the values are
10
20
30
now I want to see based on each deptno I want different
jobs like

if I am having a details like
in deptno 10 -------- clerk
analyst
manager

in deptno 20 -------- president
salesman
clerk
in 30 -------- analyst
salesman
If I pressed in deptno list item I want to disply in
job list item those appropriate values
how to do

please help me...........

thankq ...........

Report message to a moderator

Re: HOW TO ATTACH LIST ITEM VALUE BASED ON ANOTHER LIST ITEM [message #305360 is a reply to message #305346]

Mon, 10 March 2008 09:17

sispk6
Messages: 164
Registered: November 2006
Location: pakistan

Senior Member

ya ?
write code on when-list-changed
and create the record group

as from Create_group_from_query
and set the where clause of query as
"where dept = nvl(:block.list,dept)" ,

Report message to a moderator

Re: HOW TO ATTACH LIST ITEM VALUE BASED ON ANOTHER LIST ITEM [message #305642 is a reply to message #305360]

Tue, 11 March 2008 07:58

D_ashish
Messages: 20
Registered: November 2007
Location: india

Junior Member

In this example why we need to create record_group if job desc. is present in table like..

dept no. position
10 Analyst
10 Manager
20 clerk
...

can we pick then from table.

Report message to a moderator

Re: HOW TO ATTACH LIST ITEM VALUE BASED ON ANOTHER LIST ITEM [message #307159 is a reply to message #305346]

Tue, 18 March 2008 00:56

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

Previous Topic:	transfer file using webutil
Next Topic:	problem in deploying forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 02:46:54 CST 2025