Prevent Multiple bookings

[Rory898]

For my database i would like to only allow 2 games booked for one day. Is this posssible and if it is not i could just have 1 game per day?

if anyone can help i would be very grateful

Thanks

[NassauBob]

For the good people in this forum to be able to help you, a little background info on your database will go a long way toward finding the solution you want/need.

Table structure, some sample data, etc. - you know, to help visualize the sandbox you are playing in.

[Rory898]

Yeaa im sorry for leaving it so vague but ive managed to work it out by myself I just set the date field to indexed(No Duplicates) and it allowed me one booking per day which is perfect for me.

Thanks very much anyway