headers or the address bar for a form object that matches the parameter called txtSearch. 2. Click OK. The recordset appears in the Bindings panel. 3. Add all the dynamic text elements to the page, dragging the fields from the recordset into their respective positions on the page. You might also want to add captions for the field names. Figure 27.14 shows the result of the dynamic text additions. Figure 27.14. Add the fields from the recordset as dynamic text. [View full size image] Save your work and test the results in the browser. Figure 27.15 shows the search result when I type the value Dorknozzle Shirt and click Submit. Figure 27.15. The Dorknozzle Shirt was searched for and the results came back with a match. [View full size image]   As you can see, the search produced a filtered result (1 record) based on the value I entered in the search text box. Repeating Regions Now that your application has search capabilities, you might want to allow the user to see more than one item returned from the search at a time. For now, our search works fine as is because we're performing a search (Dorknozzle Shirt) that returns only one result from the EmployeeStore table. But what if the user performed a search on just the word Dorknozzle? In this case, our search would return multiple results because nearly every item in the EmployeeStore table begins with the word Dorknozzle. But would it really return multiple results? Let's try it! Type the word Dorknozzle in the search page and click Search. As you'll notice, the results page returns just the first item in our EmployeeStore table. The problem with our approach doesn't lie in the functionality we've added, rather it lies in the functionality we haven't added. Our recordset/DataSet is returning multiple results, the problem is that we haven't added functionality for repeating all the values contained in the recordset/DataSet within the search results page. To fix this problem, we need only add a repeating region. (Repeating regions were discussed at length in Chapter 25, "Working with Dynamic Data.") To add a repeating region to your results page, follow these steps: 1. Add a line break after the product cost field on the results page and highlight the section of text, including all the dynamic data. 2. Select the Repeat Region server behavior by clicking the Add (+) button within the Server Behaviors panel. The Repeat Region Server Behavior dialog appears. 3. Select the rsSearch/dsSearch option from the Recordset/Dataset menu and select the Show All Records radio button. 4. Click OK. The Repeat Region invisible element wraps your captions and dynamic text. Save your work and test the search page in the browser by pressing the F12 key. Now type a value such as shirt in the text box and click Search. Figure 27.16 shows the four records that are displayed in the results page. Figure 27.16. The Repeat Region server behavior opens the door for your users by allowing them to search for data in the database that might have more than one result. [View full size image]   Displaying Alternative Text Currently, as users search for data in the database, they are presented with results in a structured format. But suppose that users enter a value to search