Selection from one Drop down populates a second drop down list

[hardrock1997]

I have a form connected to a database. The database contains columns for project number, name, company name, address, etc.

The first drop down I would select a distinct project number, once selected I'd like the second drop down to contain a selection set of all the companies assigned to that distinct project number.

I'm assuming that this is possible?

Thanks,
Todd

[Former Community Member]

Yes but you wil need code to do it .....here is a post by Stefan Cameron that shows how to do it.

http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/

I also did a webinar on this topic for the Acrobat Users Forum ....here is a link to the recording of that webinar.

http://adobechats.adobe.acrobat.com/p69655795/

Paul

[hardrock1997]

Thanks Paul,

The 4th example in the Webinar is what we used to auto populate a users contact information when selecting their name from a drop down list. This name drop down has all the names in a particular table of the data base, we would like to filter that down by first selecting a project number from a drop down list which would cause the names to filter down to just those associated with the project number picked.

Is there scripting that can be done that can accomplish this? We can get a single name to show in the drop down but it doesn't seem to want to return a list. Any thoughts?

Thanks,
Todd

[Former Community Member]

Wouldn't it be a case of executing a more sophisticated SQL statement to have the SQL call return to you specifically what you want? I am not a SQL expert but I have seen that type of thing done before using SQL calls. I can tell you that you do not want to manipulate the returned set ...you have no vehichle for doing so.....you want to make sure the query returns specifically what you want to display.

Paul