Posted by Jerry Stuckle on 05/24/07 12:22

MissHex@gmail.com wrote:
> 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,
>

Sounds like someone's homework assignment... :-)

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]