Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Create a drop down list that populates based on the selection form another drop down list.

Avatar

Avatar
Validate 1
Level 1
ICETS_1
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
ICETS_1
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
ICETS_1
Level 1

01-06-2011

I need to set up a drop down list that is popualated (i.e. displays a certain list of selctions in the drop down list) based on the choise the form user selects in an adjacent List

For example

There are two drop down list field sitting side by side in the form

1. Select State          2. Select Course

What I want to do is have a list of states in the first drop down list (1.Select State) and depending on which state the form user selects , the second drop down list (2.Select Course) will populate with a selction of courses available in that selected state only (i.e. it will on;y show course available in QLD if QLD is selcted).

Is this hard to do?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 10
Niall_O_Donovan
Level 10

Likes

646 likes

Total Posts

4,352 posts

Correct Reply

786 solutions
Top badges earned
Validate 1
Boost 500
Boost 50
Boost 5
Boost 3
View profile

Avatar
Validate 1
Level 10
Niall_O_Donovan
Level 10

Likes

646 likes

Total Posts

4,352 posts

Correct Reply

786 solutions
Top badges earned
Validate 1
Boost 500
Boost 50
Boost 5
Boost 3
View profile
Niall_O_Donovan
Level 10

01-06-2011

Hi,

You can also use the dropdown's preOpen event, to look back at previous selections in other objects and populate the dropdown list accordingly: http://assure.ly/jcTahK

Good luck,

Niall

Answers (8)

Answers (8)

Avatar

Avatar
Level 1
Lisa_McClure
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
Lisa_McClure
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile
Lisa_McClure
Level 1

18-10-2012

Can you update this link?   I really would like to see your sample form, too.   Thanks!

Avatar

Avatar
Validate 1
Level 10
Niall_O_Donovan
Level 10

Likes

646 likes

Total Posts

4,352 posts

Correct Reply

786 solutions
Top badges earned
Validate 1
Boost 500
Boost 50
Boost 5
Boost 3
View profile

Avatar
Validate 1
Level 10
Niall_O_Donovan
Level 10

Likes

646 likes

Total Posts

4,352 posts

Correct Reply

786 solutions
Top badges earned
Validate 1
Boost 500
Boost 50
Boost 5
Boost 3
View profile
Niall_O_Donovan
Level 10

11-10-2011

Avatar

Avatar
Level 1
NguyenPete
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
NguyenPete
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
NguyenPete
Level 1

11-10-2011

I have similar situation (like the above problem where a user select a state and the 2nd list populates all the cities for that state) but instead of using Javascript and static data from the list I need to retrieve the data from a db not from a static list of Javascript.

Does that make any sense?  I know it can be done using Javascript and static data, but my data will have more data to be added later to the db.

I was able to test out fine using the recordsets and filter, but when implemented onto a form, the 2nd list didn't get populate.

Any ideas/suggestions will gladly be happy.  Thnx

Avatar

Avatar
Validate 1
Level 1
ICETS_1
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
ICETS_1
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
ICETS_1
Level 1

01-06-2011

Will look at your second option

Cheers

Avatar

Avatar
Validate 1
Level 1
ICETS_1
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
ICETS_1
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
ICETS_1
Level 1

01-06-2011

I can see the area in the script you are referring to but when I change the values to see how it works I get an error message when it tries to save which state that "does not have xmlns is cache.... this may be becuase I am using version 8 perhaps?

Avatar

Avatar
Validate 1
Level 1
ICETS_1
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
ICETS_1
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
ICETS_1
Level 1

01-06-2011

Actually it has now opened

Cheers

Avatar

Avatar
Validate 1
Level 1
ICETS_1
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
ICETS_1
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
ICETS_1
Level 1

01-06-2011

Hello Bibhu

Thanks for your quick response.  Unfortunately when I click on your link it takes me to a blank page (which I think is in Adobe Connect)

Avatar

Avatar
Validate 10
Level 4
Bibhu_Bikash_Na
Level 4

Likes

37 likes

Total Posts

630 posts

Correct Reply

46 solutions
Top badges earned
Validate 10
Validate 1
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Validate 10
Level 4
Bibhu_Bikash_Na
Level 4

Likes

37 likes

Total Posts

630 posts

Correct Reply

46 solutions
Top badges earned
Validate 10
Validate 1
Give Back 10
Give Back 5
Give Back 3
View profile
Bibhu_Bikash_Na
Level 4

01-06-2011

Hi,

Here is a form for you. Look for the scripts in the change event of Dropdowns.

https://acrobat.com/#d=oE5bec4D5UqEbuKvxugZOA

Thanks,

Bibhu.