General

Re: Populate A DropDown

Jimmy — Wed, 03 Mar 2010 02:43:24 GMT

I have responded to g21cincy's question in:

http://www.infopathdev.com/forums/p/14724/52364.aspx#52364

Re: Populate A DropDown

g21cincy — Tue, 02 Mar 2010 19:59:24 GMT

Greg,

I'm trying to populate 4 drop down lists with the same group of names. I'm guessing I'll just have to use the same solution 4 different times for each variable name. Below is an example of what I'm trying to do. Keep in mind that the first part of where they fill in their first name and last name in separate text fields is on the page before the drop-down list boxes. The user can save the data on each page. Any help on this would be greatly appreciated. I was told that I might have to create a secondary data source and programmatically add/remove items to the data source. I'm not really sure how to do that though.

Example:

These are 5 rows a user can fill out with separate boxes for the first and last names.

First Name1 Last Name1

First Name2 Last Name2

First Name3 Last Name3

First Name4 Last Name4

First Name5 Last Name5

On the next page they want these names to be populated in a drop down list as follows (the First Name and Last Name are concatenated together):

First Name1 Last Name1

First Name2 Last Name2

First Name3 Last Name3

First Name4 Last Name4

First Name5 Last Name5

Re: Populate A DropDown

Greg Collins — Wed, 25 Aug 2004 19:10:24 GMT

The example you refer to is quite complex and for advanced uses. It sounds like all you are looking to do is populate a drop-down list from a secondary data source. This is not too hard.

1. Double-click on the drop-down list box in the view.
2. In the Drop-Down List Box Properties dialog box, select Look Up Values In A Data Connection...
3. Select your ADO data connection.
4. Click the Select XPath button to the right of the Entries text box and choose the repeating field you want to use as the options in your drop-down list.
5. If your chose repeating field will not be used as both the name and value in the drop-down list, update the Value and Display Name.
6. Click OK and preview your form.

Greg Collins [InfoPath MVP]

Populate A DropDown

Wallen — Tue, 24 Aug 2004 18:36:40 GMT

Greetings.
I am trying to populate a dropdown from data that is returned from an ADO connection. I have read and downloaded the "fully editiable Dropdown example. I was completely lost. (New to InfoPath) Is there a simple way to insert information into a dropdown?

Thanks

Bill