S
simoncook
Guest
Hi
I am fairly new to Access and would like some advice on how to create a database structure (just the tables) for a small reservations system: a guest house with 15 bedrooms. I assume the following TABLES: guests, rooms, reservations. It is the latter that I am not sure of. Someone mentioned that it might be a good idea to put the dates in for a year in advance along with the roomid and then fil in the guestids as they book. In other words you have a huge table with only the dates and room ids entered. Are there any other ways
I am fairly new to Access and would like some advice on how to create a database structure (just the tables) for a small reservations system: a guest house with 15 bedrooms. I assume the following TABLES: guests, rooms, reservations. It is the latter that I am not sure of. Someone mentioned that it might be a good idea to put the dates in for a year in advance along with the roomid and then fil in the guestids as they book. In other words you have a huge table with only the dates and room ids entered. Are there any other ways
