Validation query

[StaphAreus]

I am creating a database for the local arts centre here is my question

we have several venues each with a limited capacity i am trying to create a booking system so when a venue is selected it checks for capacity at the venue. This is a one off event with one event being held at each venue so it does not need to take into acount dates just free capacity at a venue. Help

 

[Birdy]

A couple of questions spring to mind.
1. Will any other event be on at the venue at the same time.
2. Do you have the capacity for each venue held within the database.

If the answers to these are No and Yes respectively, then you could do a link to that venues capacity. If yes and yes, then the date will need to be factored in as this will reduce the number of places. The query for this would effectively be Number of places at location - Other event capacity = remaining space.

It would be best to ensure that the venue capacity is held against each location.

 

[StaphAreus]

Yes I have table called venue with the following;

Venue ID - PK
Venue Name
Venue Capacity
Venue Code

No each venue will only ever have one event

Thanks