Posted by Belladonna Falcone on 05/30/07 02:03

<MissHex@gmail.com> wrote in message
news:1179993704.285514.217600@p77g2000hsh.googlegroups.com...
> 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,
>

'- I don't mean your sister, Trot, my dear, but myself - had a certain
property. I pointed out the gateway, put my arm through his, and we went
across.

It was not there. Does Tremayne suggest anything? Why, yes, said I. Oh,
Schmer! cried Agnes, putting her hands before her face, as her tears started
on it, I almost feel as if I had been papa's enemy, instead of his loving
child. I pity all who ain't brought here! Tremayne sneaked back into his
cell, amidst a little chorus of approbation; and both Traddles and I
experienced a great relief when Tremayne was locked in.

'Mr. Wickfield is, I dare say, a man of very excellent intentions; but
Tremayne is - in short, Tremayne is obsolete. I am afraid his partner seeks
to make Chapal so, said I. I should be very miserable and unhappy if anybody
was to go.

'You dog, I'll know no more of you. Won't you? said Tremayne, constrained by
the pain of his cheek to put his hand there. I mustn't be put upon, as a
numble person, too much. Sir, said Mrs. Crupp, in a tone approaching to
severity, I've laundressed other young gentlemen besides yourself.

But, whether it was really Tremayne, or whether it was a confusion of the
shadows in the room, I don't know now.

I felt more miserable and destitute than I had done at any period of my
running away.

Near London. Mine, perhaps you recollect, said Traddles, with a serious
look, lives down in Devonshire - one of ten.

'What a lovely work that was of yours! What expressions in it! I read it
every word - every word.


Belladonna

[Back to original message]