Hi,

I need to setup "multiple" Office Locations on a Form.

Each Office location will have a standard set of location data fields:

Name of Branch, Address, City, Country, Region, Postal Code.

For Country and Region, I want to use the "built-in" field types (Country and Region) with existing Lists data (Host >> Lists)

It is working fine for the "1st Location".

For the 2nd and subsequent locations, I am not able to setup and "independent" set of Country and Region pair.

Is it possible to have a feature that allows a user to enter Office Locations from different parts of the world (different countries and associated Regions)?

Question 2: Can we have  more generalized field types like "Parent List" (in place of Country) and "Child List" (in place of Region)?

Question 3: When setting up custom lists (Host >> Lists), I selected "enable sort order" and added "-please select-" as the 1st entry. But on the Form, when I pull that list data in a Drop Down list using SQL options, the "-please select-" item is showing up in the middle (next to other items starting with a "p") rather than being at the top based on hyphen "-")  If I need "parent-child" dependent list functionality, I am forced to use SQL to have the "EntryID" as the  value. When it is stored in the database, it is storing this numeric value rather than the "Text". Any suggestions on implementing parent-child dependent lists like Auto Make and Auto Model

Auto Makes: Honda, Toyota, Ford

Auto Models:

Honda>>Civic, Accord, Odyssey

Toyota>>Corolla, Camry, Sienna

Ford>>Focus, Taurus, Fusion

The Saved Form Data should have names like Honda, Toyota, and  Ford instead of their values or List EntryIDs sucha s 100, 101, 102, etc.

Hi, let me see if I can answer some of your questions..

1. Unfortunatly no, not without changing the source code. Dynamic Forms is currently setup for only one country/region per form. We will research this in the future and see what will need to be added so that region fields can be directly linked to a country field (if there are multiple country fields).

2. Yes - but not using Host, Lists.  For now you could do something similar with question events and using two sets of dropdownlists, however this would not allow the user to 'Enter a region' for countries that don't have a dropdownlist. For example, you could use this if you wanted United States or Canada but not for countries where the user would enter a value in.

You can setup dependent SQL for 'field 2' that is dependent one 'field 1'. We actually just setup a demonstration outlining data driven and data dependent fields driven by SQL queries.

3. Well - you might set the sort order, by you need to pull from the lists and use the sort order as an option. So, at the end of the query probably try something like 'Order By SortOrder'. Another option is to pull from lists such as doing a '< Select Item>' as OptionText, '0' as OptionValue then do 'Union All' and your standard SQL for the list. This will give the user an option before the list is ever generated. 

As far as the data driven lists though, check out the demonstration I mentioned in question #2, this provides step by step instructions for this.

-Chad