Offline form drop down scenario

[Former Member]

Hi Gurus,

What is the best way to populate the drop downs for the Countries and its relevant cities in the Offline form scenario . For eg, if the user select the UK i need to populate the cites of the UK.

[Former Member]

Solved

[Former Member]

Hi,

You can create two tables in the interface structure like this:

Country (0:n)

Cities (0:n)

Country - City

You bind the country to a drop down box. After selecting a value, create some Java Script coding setting the values of the second drop down box (City box) like the following pattern:

loop over the cities

if Cities-Country == selected Country

add the city to the city drop down box

Using a web service will not be the best way because the client has to have access to the service. Firewall settings may cause problems in this scenario.

Take care,

Thomas

[chintan_virani]

Vikranth,

If the list needs to be dynamic, then you will need to write Web Services in order to get desired solution.

Alternatively since things like this do not change you can create static list i.e. hardcode the values and write some scripts to get the drop-down values populated.

In case you have Adobe Live Cycle Designer installed then open Purchase Order form from following location and check its Variables section for scripting of countries based drop-down.

C:\Program Files\Adobe\Designer 7.1\EN\Samples\Purchase Order\Dynamic Interactive\Forms

Chintan