This is my case:

1. The user select an option from a drop down list.

2. I perform a LookUp with the selected option to retrieve from SQL a list of data.

3. I need to add the data in the array in a table (one row for each data) for the user to add some information.

Example:

1. Choose between Personal or Corporate

2. If Personal was chosen return from SQL the required fields for Personal

3. Create a table for the user to index the fields:

If Personal is chosen, fields to populate the table for the user to index:

First Name:

Last Name:

Social Security Number: 

If Corporate is chosen, fields to populate the table for the user to index:

Corporate Name:

Municipal ID:

Tax ID:

Of course if the case is so simple I wouldn't use the Lookup, but my real case have dozens of choices on the first drop down list and hundreds of fields already assigned on the database to each option, and the users can add on SQL more options at will.

Appreciate your ideas.