FrontPageHowTo.com - FrontPage help & tutorials
Sample Booking Application

This application uses the FrontPage® database wizard and a little bit of custom code to create a web application that will allow companies to book you for an event. There are many more modifications that could be done to this application such as password protection and making sure the dates database cannot contain duplicate values but you will get the idea. 

The application contains the following pages. Each page contains the "How To" information for that page:

Note: Some of these pages require parameters to be passed to them so if you navigate straight to the page you will get a db results error.

The home page (this page).
Company.asp. The first page in the booking process. CLICK HERE FIRST!
Listing.asp. The second page in the listing process.
Book.asp. The final page in the booking process that writes data to the database.
Register.asp. The page used to register a company in the database so they can use the booking process.
Admin/default.htm. The default admin. page.
Admin/bookdates.asp. Lists all dates booked and by whom. This page has links to delete a booking as well as links to view the booking details.
Deletebooking.asp. When the delete link in bookdates.asp is clicked, it will post to this page which will delete the booking from the booking table and add the date back in to the list of available dates.
Details.asp. Click the detail link in bookdates.asp and this page shows you the full detail of the booking.
Adddates.asp. Allows administrator to add or remove dates to or from the database.
Removedate.asp. Processes the remove request from adddates.asp.
Fredtest.mdb. This is the database and contains these tables (Click To Download database):
Bookings Company Dates
BookingID/Autonum CompanyID/Autonum DateID/Autonum
CompanyID/Number CompanyName/text Date/Date/Time
DateID/Number ContactName/text Booked/text
  Phone/text  
  Address/text  
  City/text  
  State/text  
  Zip/text  
Global.asa. Genertated by FrontPage® when you either import the database into your web or create your first data connection.

This site was built and is maintained by DJ Web Works.
© 2000. All rights reserved.
Microsoft and FrontPage2000 are registered trade marks of Microsoft Corporation.

Hit Counter