Home » Developer & Programmer » Forms » HOW TO ATTACH LIST ITEM VALUE BASED ON ANOTHER LIST ITEM (FORMS6I)
HOW TO ATTACH LIST ITEM VALUE BASED ON ANOTHER LIST ITEM [message #305346] Mon, 10 March 2008 08:49 Go to next message
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 ...........

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 Go to previous messageGo to next message
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)" ,

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 Go to previous messageGo to next message
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.

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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

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


Current Time: Fri Dec 09 00:23:14 CST 2016

Total time taken to generate the page: 0.10934 seconds