Hysteria86
Registered User.
- Local time
- Today, 23:45
- Joined
- Oct 16, 2006
- Messages
- 11
I've a system set up that books teaching rooms for a University, with three tables (Room, RoomEquipment and Booking).
I'm looking to set up a function that allows the user to search multiple attributes of the room to see if it is already booked. The fields on the form are:
RoomID - Text box for the user to enter the roomID
Time - Text box to enter time
Date - Text box to enter date
Computers - Check box to see if the room contains computers
Desks - " " "
Projector - " " " "
I'm unsure on how to implement this, whether the use of a button that carries out a search of these, or to use some sort of query that takes input values as parameters and searches them?
I'm looking to set up a function that allows the user to search multiple attributes of the room to see if it is already booked. The fields on the form are:
RoomID - Text box for the user to enter the roomID
Time - Text box to enter time
Date - Text box to enter date
Computers - Check box to see if the room contains computers
Desks - " " "
Projector - " " " "
I'm unsure on how to implement this, whether the use of a button that carries out a search of these, or to use some sort of query that takes input values as parameters and searches them?
