the appropriate form objects to be inserted, and the unique names to be given to each of the form objects. Field Name Form Object Name DepartmentID Hidden Field departmentid Name Text Field name Username Text Field username Password Text Field password Email Text Field email Phone Text Field phonenumber Headshot Location Text Field headshotloc BillingShippingAddress Text Field billshipaddress BillingShippingCity Text Field billshipcity BillingShippingState Text Field billshipstate BillingShippingZip Text Field billshipzip Submit Button Submit   The result of inserting all these form objects is shown in Figure 26.2. Figure 26.2. Insert all the form objects for the New User Registration page. [View full size image] 6. Select the hidden field and assign it a default value of 2 in the Properties Inspector. Remember that we'll assume that all users inserted into the Employees table will belong to the Administration department when they're first created. It will be the administrator's responsibility to go back in and change the employee's corresponding department later. Save the page as register.asp, register.cfm, or register.php (depending on the server model you're using) and run it within the browser. (We'll cover the ASP.NET version of this page later in the chapter.) The result will look similar to Figure 26.3. Figure 26.3. The New User Registration page allows the employee to register for the Dorknozzle employee store. [View full size image]   Creating the Recordset Now that you have the New User Registration form created, you are ready to add the "insert" functionality. Before you can begin adding any server behaviors, however, you'll need to create a new recordset that represents the Employees table. To create the recordset, follow these steps: 1. Select the Recordset option from the Bindings panel's Add (+) menu. The Recordset dialog appears. 2. Give the new recordset the name rsNewEmployee. 3. Choose the connDorknozzle option from the Connection menu. 4. Choose the Employees option from the Table menu. The completely formatted Recordset dialog should resemble Figure 26.4. Figure 26.4. Format the Recordset dialog box accordingly. 5. Click OK. The Bindings panel now shows the fields contained in the recordset, also shown in Figure 26.5. Figure 26.5. The Bindings panel lists the fields in the recordset. Validating the Form Now that you have the recordset created, you are ready to begin inserting the data into the database. But before you begin, you'll want to add functionality that guarantees the data going into the database is valid. Because the database tables explicitly define data types for each field, you'll want to make sure that the data the user enters is the same as what is going to be accepted by the