![]() |
![]() |
![]() |
![]() |
Mapping Tables and Lists to the database
Open the database editor if it is not already open by choosing 'Database Editor' from the Database menu, and select the UI Mapping page.
Next you will set up the Database Editor to display the descriptions in the Listbox you just created.
- On the UI Mapping page, select "DESCRIPTION" in the tree.
- Choose "listOfDescriptions" from the list on the right. There will now be two items under "DESCRIPTION" in the tree, indicating that the Description column will be displayed by both the 'description' text field and the Listbox.
Next you will display the information in the table that you added as well.
- Select "PRODUCT_NUM" in the tree.
- Choose "jTable" from the list on the right. There will now be two items under "PRODUCT_NUM" in the tree.
- Select "DESCRIPTION" in the tree.
- Choose "jTable" from the list on the right. There will now be three items under "DESCRIPTION" in the tree.
- Map "PURCHASE_COST" in the tree to "jTable" in the same manner.
- Map "QTY_ON_HAND" in the tree to "jTable" in the same manner.
We will now use the listOfDescriptions to select rows from the results.
- Select "<Goto Specific Record>" in the tree.
- Choose "listOfDescriptions" from the list on the right. Now, whenever you choose an item from your list, the rest of the display will be updated as well.
- Press the apply changes button to update the changes in your working model.
We have finished adding items to your application. You can test your changes the same way you did previously. This time note that when you hit the "previous" and "next" buttons, the highlighted row changes in the Listbox and in the table. If you choose an item from the list, then the text fields and the table immediately update to show which row was chosen.
Data Representations, Inc. http://www.datarepresentations.com support@datarepresentations.com sales@datarepresentations.com |
![]() |
![]() |
![]() |
![]() |