|
Posted by MissHex on 05/24/07 08:01
Hello everyone,
am building a housing system
and i want to be able to seach the data base for empty rooms then
assign no more than 2 students in each room
i have a table Student that contains Student ID
and a table Room that contains the room ID
i built another table that contains the roomID and the StudentID
but how can i limit the entries to the rooms to make no more than two?
and also search if for empty spaces?
thank you very much in advanced
regards,
Navigation:
[Reply to this message]
|