Plough Farm Database Instructions - Handling Data

Setting up Relationships between Tables

Before putting data in to the database it is best 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 use queries to SEARCH and SORT a database...

• Open up your database from My Documents
• Click on the relationship button on the 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 Accommodations Table on the right
• Drag the customer number field in the customers table on to the customer number field in the bookings table. Put a tick in the Referential integrity box and click create.
• Now drag the Accommodation type field from the Accommodation table on to the Accommodation type field in the bookings 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