To book a date, select your company name from the drop down list.
If you are not listed, click here to register..

NOTE: You must select a company and click Submit in order to properly see the table of information on the next page, book.asp. You may also choose to register your own sample company information as well by clicking the link above.

 

How To....

  1. Insert a form field on to the page - Insert | Form | Form.
  2. Delete the Reset Button.
  3. Position the cursor inside the form.
  4. Launch the database results wizard - Insert | Database | Results.
  5. Select your database connection. Click Next
  6. Select "Company" as the record source. Click Next.
  7. In step three of the wizard, click the Edit List button. Remove all fields except CompanyName and CompanyID. Click OK.
  8. Click Next to move to step four.
  9. In step four, select the options as shown in this image:

  1. Click Next.
  2. Click Finish.

It is important that in step four of the wizard (step 9 above) that the "Submit values from this field:" drop down is set to the CompanyID because we are going to be passing this as the parameter to the next page.

  1. Now, right click on the Submit button and select Form Properties...
  2. Give the form a name and select Send To Other as shown below:

  1. Click the options button.
  2. Fill in the action box with the name of the page we are submitting to (listing.asp):

  1. Click OK twice.
  2. Save page as company.asp.

Your page should look like this:

That completes this page. When displayed, you will be able to select the company name from the drop down, click the submit button and pass the CompanyID to the listing.asp page to display more results. To further enhance the page, consider using the "onchange" command to make the form auto submit without having to click Submit. See the onchange tutorial for more information.

^ Top Of Page