Record dialog. [View full size image] 7. Click OK. The Insert Record server behavior appears in the Server Behaviors panel, and your form is highlighted in blue (because it is an invisible element). Save your work and test the result in the browser by pressing F12. Enter values into the text fields and click Submit. If everything functions smoothly, the page refreshes itself. Remember that the refreshing of the page happens because we didn't identify a page to redirect to after the data from the form is inserted into the database. We'll do that in the next section. To verify that the data was in fact inserted into the Employees table, open your respective database and look in the Employees table. A new user should be created similar to Figure 26.9. Figure 26.9. The values from the form should go directly into the Employees table. [View full size image]   NOTE One of the most common problems I have found when working in Dreamweaver is that of inserting records into the database. Generally this problem is isolated to the ASP server model using Access. This is one of the areas where errors in the browser occur quite often. In most cases, this issue isn't a problem with Dreamweaver, but rather, it has more to do with the fact that Write permissions have to be enabled for the database. If you receive HTTP 500 errors, connection errors, and so on, refer to the companion website at www.dreamweaverunleashed.com for troubleshooting tips.   Creating the Redirection Page The final step we'll want to perform before we can call the New User Registration page complete is to add the functionality that will redirect the user to a thank-you page of some sort after they've registered. You can create this functionality by following these steps: 1. While still in the New User Registration page, double-click the Insert Record server behavior. The Insert Record dialog reappears. 2. Enter the value x_newusercreated.asp in the After Inserting, Go To text box. If you're working with ColdFusion, enter x_newusercreated.cfm and if you're working with PHP, enter x_newusercreated.php. The Insert Record dialog should resemble Figure 26.10. Figure 26.10. Add the redirection page as a value in the After Inserting, Go To text box. [View full size image] 3. Click OK. Save your work. 4. We'll need to create a new page that represents that redirection page. To do this, select File, New. In the New Document dialog, switch to the Template tab and highlight the template named Template for the site you're working with and click Create. 5. In the new page, replace the text Content Goes Here in the Content editable region with the text Thank you for registering as a new user. The result will resemble Figure 26.11. Figure 26.11. Add some welcoming text to the new page. [View full size image] 6. Save your page as x_newusercreated.asp, x_newusercreated.cfm, or x_newusercreated.php depending on the server model you're working with.