Importing a list for a drop down - InfoPath Dev
in

InfoPath Dev

Importing a list for a drop down

Last post 08-19-2006 12:48 AM by Shiraz Cupala. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next
  • 08-18-2006 08:48 AM

    Importing a list for a drop down

    Hi everyone,
    I am adding a drop down box in infopath that has every state and province. How can I do this so I don't need to manually imput each one?

    Thanks in advance
  • 08-18-2006 10:24 AM In reply to

    Re: Importing a list for a drop down

    Hi and welcome to our forum. The best way is to create a separate XML file with this information and then add it as a Data Source which the dropdown can use. The XML file would look something like:

    <StatesProvinces>
    <StateProvince>California</StateProvince>
    <StateProvince>Oregon</StateProvince>
    <StateProvince>Washington</StateProvince>
    <StateProvince>British Columbia</StateProvince>
    </StatesProvinces>

    You of course fill in the rest. Create this in notepad and save the file and rename it with a .XML extension. Then in InfoPath create your dropdown, select to look up options from a data connection, and add in a receive data connection that uses this XML file you created.

    Shiraz Cupala / Microsoft InfoPath MVP
    Qdabra® Software / Streamline data gathering to turn process into knowledge
  • 08-18-2006 11:51 AM In reply to

    Re: Importing a list for a drop down

    Once again thankyou SHiraz, but once again I have a quick question. Like in my other topic if I have the template for an individual and stateprovince is one of the fields, will it fill out the textdrop or do I need to stick with text fields?
  • 08-18-2006 11:57 AM In reply to

    Re: Importing a list for a drop down

    It's ok to still have the dropdown. You just have to be sure that in your "template" the exact same value is used for the state/province as corresponds in your state/province lookup.
    Shiraz Cupala / Microsoft InfoPath MVP
    Qdabra® Software / Streamline data gathering to turn process into knowledge
  • 08-18-2006 12:15 PM In reply to

    Re: Importing a list for a drop down

    Excellent, thankyou for all of your help, on both topics!
    You have an good day.
  • 08-19-2006 12:48 AM In reply to

    Re: Importing a list for a drop down

    You're welcome. Glad to help out. :)
    Shiraz Cupala / Microsoft InfoPath MVP
    Qdabra® Software / Streamline data gathering to turn process into knowledge
Page 1 of 1 (6 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.