in the browser. The result looks similar to Figure 26.40. Notice that you can page through five records at a time. Figure 26.40. You can now page through five records at a time. [View full size image]   Deleting Records Up to this point, we've simply provided a mechanism for displaying and paging through the data contained in the EmployeeStore table. So far, we've merely provided an alternative method (using application objects) for functionality that was outlined in the previous chapter. This section is where the functionality begins to change. In this section, we'll manually create a new column in the dynamic table, exposing functionality that will allow an administrator to delete certain products from the EmployeeStore table. To add this functionality, follow these steps: 1. Add a new column to the dynamic table by right-clicking the ItemID column and selecting Insert Column from the Table submenu. A new column appears to the left of the ItemID column. 2. Place your cursor in the first cell of the first row and choose Insert, Form, Button. A new button is inserted in the cell. 3. Select the button and change the value to Delete in the Properties Inspector. Also, select the None radio button from the Action radio button group. 4. Select Insert, Application Objects, Delete Record. The Delete Record dialog appears. 5. Choose the connDorknozzle option from the Connection menu. 6. Choose the EmployeeStore option from the Delete From Table menu. 7. Choose the rsProducts option from the Select Record From menu. 8. Select the ItemID option from the Unique Key column menu. 9. Make sure that the form1 option is selected in the Delete By Submitting menu. The formatted Delete Record dialog resembles Figure 26.41. Figure 26.41. Format the Delete Record dialog. [View full size image] Save your work and test the admin page in the browser. Navigate a few records and click the Delete button. The page refreshes itself, and the selected row disappears. Check the EmployeeStore table to confirm the deletion. Master Detail Page Set The Master Detail Page Set application object is one of the most powerful objects built into Dreamweaver. It enables you to create a single page with as many fields from the recordset as you like. You can then make one of the items linkable so that it hyperlinks to a detailed page, exposing more detailed information about the linked item. In our example, we'll use the Master Detail Page Set to link the ItemName field to a second page that provides more information about the selected item. How much more information can we provide? Remember that we excluded the Description and ImageURL fields when we created the DataSet earlier in the chapter. Because these fields are relevant to the item, we'll expose these in a detailed page to which we'll link from the master page. You can work with the Master Detail Page Set by following these steps: 1. Start by creating a new page. Select New from the File menu, choose the template from the defined Dorknozzle site, and click Create. 2. Immediately save your page as admin_master.asp, admin_master.cfm, or admin_master.php, depending on the server model you're using. 3. Create a new recordset. To do this, select Insert, Application Objects, Recordset. The Recordset dialog appears. Enter the name dsProducts, select the