We have designed a form, containing a List -Box and a Table, in Adobe LiveCycle.
The List Box, containing Product Codes (displayed) and corresponding Product Rates (hidden), is populated from a database.
We want that users should be able to select multiple Product Codes from the List Box, and the same Product Codes, along with their corresponding Rates, should get populated in appropriate columns of the Table in LiveCycle.
The Table (in the same Form) has two columns -- Product Code and Product Rate. Both these values should be displayed/populated based on the selected Product Code from the LiveCycle List- box.
The form also contains a Command Button (name - Assign). The table should be populated with all the selected entries from the List Box once the user clicks on the Assign button.
Thanks for the response. But would like to draw your attention that I have implemented the solution (code script) as provided by you within the form we have designed, with necessary modifications as per form design. I have put the code in the click event of the Assign button. However, no data is being populated in the table based on the items selected from the list box. I am attaching the screenshots showing that the list box is being populated from database (MySQL) but nothing is populated in the table. The screenshots are for your reference.
List box gets populated from database
After clicking the Assign button
Kindly observe that no data is being populated in the table from List box (based on items selected).