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.
- Click Relationships tab from left panel. Delete any existing relationship – right-click and click Delete.
- Click Manage Relationships on the ribbon and click New.
- Select the tables and columns that are related – Booking.BookingId → BookingAttendees.BookingId – tick Make this relationship active then click OK.
- 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.