database for lodging

  • Thread starter Thread starter Reyna
  • Start date Start date
R

Reyna

Hi,

I am trying to set up a database for people going to campsite for the
weekend. I have the client list and info set up. But how do I set up what
cabins they will be staying in? Do I set up a separate table for each cabin
with a list of beds in each cabin?

And how do i set it up so that each bed can only be assigned to one person?

Reyna
 
Thank you Steve. I will probably post again. Once I have the tables setup,
I'll be looking for help on ogther issues. : )

R
 
Another lousy design by stevie. Nothing was mentioned about membership, but
if it is a requirement, then TblClientID and TblClientMember should be one
table.

Also, you need to clarify your facts before jumping in with a design. Is
Renya concerned about individual bed rentals or making sure that occupancy
does not exceed the cabin's capacity? Are these beds/cabins being rented to
individuals who will share or to families? If a family of four rents a cabin
with five beds, can the fifth bed be rented? You need to check your facts.

John...
 
Reyna said:
Thank you Steve. I will probably post again. Once I have the tables
setup,
I'll be looking for help on ogther issues. : )

R
Click to expand...


Be careful working with steve. His only interest is to seperate unknowing
newsgroups poster from their money by providing a less than satisfactory
product.

These newsgroups are provided by Microsoft for FREE peer to peer support and
there are many people who are far more qualified than steve who are more
than willing to help.

Before you go stumbling off and following steve's design, I have a few
comments.

1) The TblClientID and TblClientMember should be one table.

2) Are you concerned about individual bed rentals or making sure that
occupancy does not exceed the cabin's capacity?

3) Are these beds/cabins being rented to individuals who will share or to
families? If a family of four rents a cabin with five beds, can the fifth
bed be rented? You need to check your facts.

These questions will help you get a proper design.

John... Visio MVP
 
John... Visio MVP said:
Another lousy design by stevie. Nothing was mentioned about membership, but
if it is a requirement, then TblClientID and TblClientMember should be one
table.

Also, you need to clarify your facts before jumping in with a design. Is
Renya concerned about individual bed rentals or making sure that occupancy
does not exceed the cabin's capacity? Are these beds/cabins being rented to
individuals who will share or to families? If a family of four rents a cabin
with five beds, can the fifth bed be rented? You need to check your facts.

John...
Click to expand...

Hi John,
Have you seen the recent account Steve uses?

(e-mail address removed)
Indeed, indeed! Hilarious!!


He is switching accounts like a maniac (Maybe he *is* a maniac?)
A while ago he used:
(e-mail address removed)
Last weeks he used:
(e-mail address removed)
Now he is switching from:
(e-mail address removed) and (e-mail address removed) to
(e-mail address removed)


What is he trying to hide ??

Arno R
 
Back
Top