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?
Solved! Go to Solution.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Hi,
Here is a form for you. Look for the scripts in the change event of Dropdowns.
https://acrobat.com/#d=oE5bec4D5UqEbuKvxugZOA
Thanks,
Bibhu.
Views
Replies
Total Likes
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)
Views
Replies
Total Likes
Actually it has now opened
Cheers
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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?
Views
Replies
Total Likes
Will look at your second option
Cheers
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Hi,
I would recommend some posts from Stefan Cameron's blog:
http://forms.stefcameron.com/2006/09/18/connecting-a-form-to-a-database/
http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/
http://forms.stefcameron.com/2006/12/18/databases-inserting-updating-and-deleting-records/
http://forms.stefcameron.com/2006/12/07/better-form-design-with-xfa-25/
Hope that helps,
Niall
Views
Replies
Total Likes
Can you update this link? I really would like to see your sample form, too. Thanks!
Views
Replies
Total Likes
Views
Likes
Replies