value populated in Drop down list through formcalc/java script

[Former Member]

Hi,

I have two tables like table1, table2.

Table 1 structure --- number, name, std.

table2 structure --- number , key, value.

table1 values

number name std

1 A X

2 B C

Table2 values

number key value

1 A1 B1

1 A2 B2

1 A3 B3

2 C1 B2

2 C2 B3

2 C3 B4

I need to compare table1-number = table2 number...move value field values B1, B2 and B3 to drop down list.

Like that for next line item. How can I achieve this through Formcalc/Javascript.

Thanks

GJ

[Former Member · Accepted solution]

here's a link to some scripting documentation

http://www.adobe.com/devnet/livecycle/articles/lc_designer_scripting_basics/lc_designer_scripting_ba...