Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Populating Table Dynamically From Database Table Based on Dropdown Selected

Avatar

Avatar
Level 1
saugata74
Level 1

Likes

0 likes

Total Posts

10 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
saugata74
Level 1

Likes

0 likes

Total Posts

10 posts

Correct Reply

0 solutions
View profile
saugata74
Level 1

22-10-2015

Dear All,

Need an urgent help in designing a database driven form.

I have designed a dynamic form which among other objects contains two form objects that are dependent on a Product table. These two form objects are a table and a drop-down list. The fields that are required in the form are Product Code, Product Grade and Rate.

Now the form has to be designed in such a way that all Product Grades from the Product table get populated in the drop-down list. The form should enable the user to select a single or multiple Product Grade from the drop-down list. There is also an Assign button that user need to click after selecting Item(s) from drop-down list. The actions that need to be performed are:

  • When user clicks on the Assign button, the table row(s) get populated based on Product Grade(s) selected. The first column of the table will display the selected Product Grade and the second column will display the corresponding Rate.
  • User can select multiple Product Grades from the drop-down list. In that case Product Grade and matching Rate should be displayed in multiple rows of the table.
  • Product Grade once selected cannot be selected again from the drop-down list.

I have been able to successfully display all Product Grades from the Product table in the drop-down list. But could not proceed ahead with the actions as specified above.

For the same I seek an urgent solution. Kindly mail me the solution at my mail id – saugata74@gmail.com.

Seeking the help on urgent basis.

Regards,

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 2
PriyankP
Level 2

Like

1 like

Total Posts

28 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
PriyankP
Level 2

Like

1 like

Total Posts

28 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
PriyankP
Level 2

23-10-2015

To allow selection of multiple items from a list of items (without allowing duplicate selections), i suggest you use a ListBox instead of a dropdown list. Dropdowns are typically useful for a single value selection out of multiple values.

To populate table values from Database dynamically you will have to make a SOAP based webservice call from within the form. There are number of examples available on internet to show you how to make WS call from the form. But - remember, you will need to use Reader Extensions on the form to make Web service call from the form. And there is an additional licensing fees for applying reader extensions to the form.

Hope it helps !