A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Hotel Booking Project Delemma



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old October 6th, 2005, 08:59 PM
Abe
external usenet poster
 
Posts: n/a
Default Hotel Booking Project Delemma

I am having a dilemma with a Hotel Booking Project which is
a small part of a larger project.
If someone can help me with this, or refer me to a sample DB
it would be seriously appreciated!

I have my tables set up as follows.
tblMembers one to many tblHotelBookingsToMembers
tblHotelBookings one to many tblHotelBookingsToMembers
(This is setup in the same manner as the Products, Order Details,
Orders tables in the Northwind DB)

In the tblHotelBookings I have fields to capture Number of Nights,
& Persons for each booking
If two members are staying in the same room,
I book them each individually under the same HotelBooingID
in tblHotelBookings
So let's say that HotelBookingID 1001 has 3 Nights & 2 Persons.

Because each member (John & Mary) is linked to HotelBookingID 1001,
when I try to create a report or query, that sums the number of room nights
and persons, I get duplicate values. 6 nights & 4 persons

Essentially I am trying to figure out how I can book two Members into
the same hotel (specific room #s aren't captured) so that each member has
a booking in my DB and I can design a report that will show the number of
persons & nights for each booking without duplicates. This info has to be
passed on to the Hotel.
Lets see if I can be more clear...
If one member (John) is booked, but has a second person (i.e. Spouse)
staying with him who is NOT a Member, then I do NOT need to
show a booking for that second person in my DB.
I simply indicate 2 persons. So I only have ONE booking. No problem.
But if his spouse is a member then I must also book that person into the DB,
which creates 2 members for the same HotelBookingID

Any advice or help is welcome!
Thank You!

PS: If more clarity is needed, feel free to indicate so.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Project and Employee Relationship Jason General Discussion 3 March 30th, 2005 06:45 AM
How do I create a fairly simple hotel booking system? law Database Design 1 February 19th, 2005 11:27 AM
Union Query Not Returning A Value Jeff G Running & Setting Up Queries 2 October 19th, 2004 05:47 PM
Signing a VBA mde/mdb Access 2003 John Buckett General Discussion 3 July 3rd, 2004 09:14 PM
Table design for a booking system Brian C Database Design 2 April 27th, 2004 03:11 AM


All times are GMT +1. The time now is 10:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.