Table populated based on date

[Master Klick]

I'm building a small database to track rooms at an Inn. I have one table that tracks bookings which includes the room booked and the start and end date of the booking. I have another table that lists all the rooms. I would like one more table that either lists all the rooms that are currently booked, or one that lists all the rooms excluding those booked.

This doesn't have to work well in a real life application, it just has to kind of work.

[ranman256]

you already have this...
the tRooms table will have the room ,etc data , and OccupiedBy
Room, Occupied
1, null
2, 321
3, null
4, 77

the client ID will appear in tRooms.OccupiedBy
null means it is empty.

make 2 queries:
qsBookedRooms, select * from tRooms where Occupiedby is not null
qsEmptyRooms, select * from tRooms where Occupiedby is null

[Master Klick]

Ok, but how do I make the OccupiedBy dynamic? I can get that to work for one instant, but I can't get it to make the room available again after the end date.

I've never been able to get access to work in four dimensions.