Finding the right formula...
I am working for a client doing a database for a residence that has different rooms.... What they need basically is to know how many beds are occupied or lefet in each room... For instance, there is room 23 which is quadruple, 22 a double, 21, a single.... There are 2 people uccupying No 23 so 1 bed left... they want to have a screen that lets them know this data..who is where and how many beds are free... I must admit I have some problems to find out the best way to do that ....new database with relationship ? Or could I do that with only one... Not really mathematical ...if anyone could helpd me on this I'll really be gratefull... many thanks