Same items can not be booked on the same day and time by another


Hello there,

I recently started using Airtable and am still finding my way around and working on new things.

I am trying to create a booking system on Airtable. I have so far successfully created a calendar view where I can visually see on what day which customer has booked an item for; when I click on the customer name, I can see in the dialogue box the list of items they have booked. My customers can book an item on any day at any time. The problem i’m having is, another customer should not be able to book that same item on the same day and time, but they can book it for a different day and time.

Is there something on Airtable, or even a work around which can help me solve this problem? Please let me know if I need to elaborate on something.

Thank you in advance.