Showtime Database Instructions - Handling Data

Setting up Relationships between Tables

Before putting the rentals in to the database you have to set up any relationships between tables

Relationships allow you to set up queries on a database that can show fields from more than one table.

We can then set up a query that will allow us to make a bookings form...

• Open up your database from My Documents
• Click on the relationship button oCe top tool bar
• Select all three tables to be shown in the relationship window
• Put the Customers Table on the left, the Bookings Table in the middle and the Videos Table on the right
• Drag the customer number field in tblcustomers table on to the customer number field in the tblbookings table. Put a tick in the Referential integrity box and click create.
• Now drag the Video Reference Number field from the tblvideos table on to the Video Reference Number field in the tblbookings table. Put a tick in the Referential integrity box and click create.
• Click on the save button to save the relationships.
  
  

  ---

BACK TO MAIN PAGE