is sent to the server-side application. To insert the behavior, follow these steps: 1. Open the Behaviors panel by choosing Window, Behaviors. Choose the Submit button form object on the page and select the Validate Form behavior from the Behaviors panel. 2. The Validate Form dialog appears. Choose E-mail Address for the E-mail field and choose Required for all the other fields. The result is shown in Figure 26.6. Figure 26.6. Select the appropriate options from the Validate Form dialog. 3. Click OK. Save your work and test the results in the browser by pressing F12. Typing incorrect data (specifically in the Email text box) or forgetting to type data in all the fields results in an error message similar to the one shown in Figure 26.7. Figure 26.7. An error message is displayed if data is missing or is inconsistent.   Inserting a New User into the Employees Table Now that you can verify that the data being sent to the database is in fact legitimate, you can now build the functionality for adding the data to the Employees table. To facilitate this process, Dreamweaver provides an Insert Record server behavior that allows for quick and intuitive insertions into the database table of your choice. To insert a new employee into the Employees table, follow these steps: 1. Place your cursor in the form and select Insert Record from the Add (+) menu of the Server Behaviors panel. The Insert Record dialog appears. 2. Select connDorknozzle from the Connection menu. NOTE Depending on the server model you decide to use, the Insert Record dialog looks slightly different. Don't worry about the differences because all the functionality is equally represented across server models. It's merely the ordering of the features that's different. 3. Choose the Employees table from the Insert Into Table menu. 4. Leave the After Inserting, Go To text box blank for now. The value you enter here will be used as a redirection page after the new user has successfully registered. We'll define this in the next section. 5. Make sure that the form1 option is selected from the Get Values From menu. 6. The form elements selection box enables you to match up a form object with the corresponding field in the database. In most cases, Dreamweaver figures out the match between the text field name on the form and the database table's field name. If some do not match however, the value <Ignore> appears. If this is the case, simply select the appropriate match from the column drop-down list. Refer to the following chart for a reference on which form elements correspond to which field values. Form Element Column Submit as departmentid DepartmentID Numeric Name Name Text username Username Text Password Password (Pass in Access) Text Email Email Text phonenumber Phone Text headshotloc Headshot Text billshipaddress BillingShippingAddress Text billshipcity BillingShippingCity Text billshipstate BillingShippingState Text billshipzip BillingShippingZip Text