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 list you just created.

1. On the UI Mapping page, select "DESCRIPTION" in the tree.
2. 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 list.

Next you will display the information in the table that you added as well.

3. Select "PRODUCT_NUM" in the tree.
4. Choose "bigTable" from the list on the right. There will now be two items under "PRODUCT_NUM" in the tree.
5. Select "DESCRIPTION" in the tree.
6. Choose "bigTable" from the list on the right. There will now be three items under "DESCRIPTION" in the tree.
7. Map "PURCHASE_COST" in the tree to "bigTable" in the same manner.
8. Map "QTY_ON_HAND" in the tree to "bigTable" in the same manner.

We also want to use the list and the table as a selection mechanism to select rows from the results and have the reset of the application sync up.

9. Select "<Goto Specific Record>" in the tree.
10. Select "listOfDescriptions" and "bigTable" from the list on the right. Now, whenever you choose an item from your list or table, the rest of the display will be updated as well.
11. Press the apply changes button to update the changes in your working model.

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 list and in the table. If you select an item from the list or the table, then the text fields immediately updates to show which row was chosen.