Manage relationships

The relationship between the tables BookingID is many-to-many. This is because recurring bookings share the same BookingID and fixed and flexible desk booking records do not have a BookingID, making the BookingID non-unique in the booking table.

Check and edit the relationships between tables.

1. Click Relationships tab from left panel. Delete any existing relationship – right-click and click Delete.
   

2. Click Manage Relationships on the ribbon and click New.

3. Select the tables and columns that are related – Booking.BookingId → BookingAttendees.BookingId – tick Make this relationship active then click OK.
   

4. Click Close.
   

Your final relationships should look like this:

All three tables are now set up. Switch to the Report tab to create your first report.