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.
  1. Click Manage Relationships on the ribbon and click New.
  1. Select the tables and columns that are related – Booking.BookingIdBookingAttendees.BookingId – tick Make this relationship active then click OK.
  1. 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.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Please do not use this for support questions.
Condeco Support

Post Comment