If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hostel Database Setup
Thanks to all of you for all of your help.
I have a small backpackers hostel and I am currently working on a database to help me keep track of all of my guests. These are the two basic design issues that I am running into. Issue 1. Sometimes, there are 2 or 3 guests staying to gether in a private room (as opposed to individuals staying in dorm beds which are always registered separately). Since we rent the private rooms by the room, groups are considered to be one booking and one stay in one room, even though there are three individuals. I want to keep track not only of the guest that is the official guest in my register (the one who pays for the room), but the 2 people who are accompanying him. Why? Because I a) want to know how many different individuals have walked through my doors b) I want to know the nationalities of every individual and c) Many times one of the people who have stayed as a friend of a guest in a private room, will come back on their own a few days later, and then they might become the paying guest or an individual in a dorm. Therefore, I want a way that every single person has a client ID number. I have managed to do this rather haphazardly...by having a table with the following fields, MAIN GUEST 1(TITLE) clientid1 lastname1 firstname1 nationality1 etc1 FRIEND2 (TITLE) clientid2 lastname2 firstname2 nationality2 etc2 FRIEND 3 (TITLE) clientid3 lastname3 firstname3 nationality3 etc3 And I just go in and manually assign a number to each person. Tried using subforms, could't get them to work. Didn't use autonumbers because I wasn't sure how to deal with the following Issue 2 below..... Issue 2. Repeat Bookings. I currently have a booking table which allows each guest to have a booking with dates, prices, room choice, etc. How do I deal with repeat bookings of the same person? How do I structure tables and forms to deal with the infinite amount of booking data that might apply to one guest since I have no idea if a person will come back 0 times, or 3 times or 65 times, or if they will be in the same room the next night, etc. How do I limit my table and form size? How can I pull up a client number say 55, and then enter new booking records? Should I do this with individual booking tables? And once again, are my problems solve with autonumbers? Finally, let me explain why I want this data... To present real and true financial and marketing data to perspective buyers of my business. To answer my guests questions, eg, "How many guests have you had?" "What country are the majority of your guests from?" "How many Swiss visitors have you had?" "Are most of your guests under 30?" etc. I would really appreciate someone's opinions. (PS, I am a relative newbie, and know nothing about programming language.) AndreainPanama you can see my webpage at www.purplehousehostel.com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I setup an interactively editable database? | Hunt4868 | New Users | 2 | January 13th, 2006 03:08 AM |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
Access Error Message when opening database | eah | General Discussion | 3 | January 26th, 2005 10:04 AM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |
Office XP | Ed Lester | Setup, Installing & Configuration | 1 | May 27th, 2004 09:30 AM |