OraFAQ Forum: Forms » How to Populate Combo Box Dynamically based on another Combo Box- URGENT PLZ..

Home » Developer & Programmer » Forms » How to Populate Combo Box Dynamically based on another Combo Box- URGENT PLZ..

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

How to Populate Combo Box Dynamically based on another Combo Box- URGENT PLZ.. [message #189517]

Fri, 25 August 2006 00:12

sireeshraju
Messages: 32
Registered: October 2005

Member

hello ,

I have a combo box,If I select a value from this combo box it should populate another Combo box automatically.

Example:-
state
sno cno statename
1 1 newyork
2 1 boston
3 1 florida
1 2 brisbane
2 2 sydney
country
cno country name
1 usa
2 Aus

if i select usa in first combo box
in next combo box i have to poulate only states that belong to that country.

BY example above:
If in first combo box i select AUS
then in next combo box i.e., in
second combo== brisbane
sydney only must be there .
i need the exact code with trigger.

Any Help is highly appreciated.
Regards
Sireesh.K

Report message to a moderator

Re: How to Populate Combo Box Dynamically based on another Combo Box- URGENT PLZ.. [message #189635 is a reply to message #189517]

Fri, 25 August 2006 06:00

sireeshraju
Messages: 32
Registered: October 2005

Member

Can anyone Answer my Question Please.

Regards
siri....

Report message to a moderator

Re: How to Populate Combo Box Dynamically based on another Combo Box- URGENT PLZ.. [message #189734 is a reply to message #189517]

Sat, 26 August 2006 01:14

sameer_am2002
Messages: 129
Registered: September 2002

Senior Member

Check for attached Files RECORDGROUP.fmb

In this first copy all contents in TABLE_SCRIPT PROGRAM UNIT AND RUN IT ON SQL..THEN DELETE THIS PROGRAM UNIT..ND THEN RUN THE FMB..