Check Date and Availability

[keldeco]

I'm trying to create a database that will keep track of scheduling. I need it to check a date and time specified and make sure that there are enough available seats. I have fields: name, date, time, seats available, and seats needed. First it needs check the date and time specified to see if the number is >0 then when they sign up it needs to decrease the number of seats available by the number of seats needed.
I'm so lost! Any insight would be wonderful!

 

[Guest_imported]

Are you really an MIS?

For a start, it sounds like you've thrown normalisation out the window.

How is this being done? If by code on a form then try this

If Me.txtDate > 0 Then
If Me.txtSeatsAvailable <= Me.txtSeatsNeeded Then
Me.txtSeatsAvailable = Me.txtSeatsAvailable - Me.txtSeatsNeeded
End IF
End If

This is a very simple and straight forward example. However, being a lover of fine musicals, I actually like to sit next to the people I arrived with. These complexities may come into play. It depends if you have Ushers directing people where to sit.