Hello,
I work across a number of small venues which have art cases that can be booked for displays. I am trying to build a simple data base to report what space is available and also what art is currently being displayed. The art is usually booked by month, but sometime it can be booked for a week etc.
I have set up 3 tables
Art Inventory
Art Cases by Venue
Art Case Bookings
In the art case booking form, I have set up the start and end date but I cannot figure out how to avoid double bookings of a case? Once I have that worked out I believe I know how to build the required reports for my needs.
I know there are number of other posts about this sort of database but I am self taught and get totally lost when people start posting code. I've attached a copy of my database to this thread.. if anyone could help that would be amazing!!
thank you
Francis
Art booking system for venues.zip