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
TblClientID ClientID ClientLastName <Client Fields As Needed> TblClientMember ClientMemberID ClientID ClientMemberLastName ClientMemberFirstName <Client Member Fields As Needed> TblCabin CabinID <Cabin Fields As Needed> TblBedInCabin BedInCabinID CabinID BedNumber TblCabinRental CabinRentalID CabinID ClientID DateStart DateEnd TblBedAssignment BedAssignmentID CabinRentalID BedInCabinID ClientMemberID Steve "Reyna" wrote in message news:1E405A1B-AECA-48BF-980A-FE4FBB51FADE@microsoft.com... > 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 "Steve" wrote: > TblClientID > ClientID > ClientLastName > <Client Fields As Needed> > > TblClientMember > ClientMemberID > ClientID > ClientMemberLastName > ClientMemberFirstName > <Client Member Fields As Needed> > > > TblCabin > CabinID > <Cabin Fields As Needed> > > TblBedInCabin > BedInCabinID > CabinID > BedNumber > > TblCabinRental > CabinRentalID > CabinID > ClientID > DateStart > DateEnd > > TblBedAssignment > BedAssignmentID > CabinRentalID > BedInCabinID > ClientMemberID > > Steve > > "Reyna" wrote in message > news:1E405A1B-AECA-48BF-980A-FE4FBB51FADE@microsoft.com... > > 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 > > >
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... "Steve" wrote in message news:a5WdnexX-9LOV-7VnZ2dnUVZ_jSdnZ2d@earthlink.com... > TblClientID > ClientID > ClientLastName > <Client Fields As Needed> > > TblClientMember > ClientMemberID > ClientID > ClientMemberLastName > ClientMemberFirstName > <Client Member Fields As Needed> > > > TblCabin > CabinID > <Cabin Fields As Needed> > >>> 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 > >
"Reyna" wrote in message news:52406583-AF97-46A6-94CB-5A39BACB85F4@microsoft.com... > Thank you Steve. I will probably post again. Once I have the tables > setup, > I'll be looking for help on ogther issues. : ) > > R 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
"Steve" schreef in bericht news:a5WdnexX-9LOV-7VnZ2dnUVZ_jSdnZ2d@earthlink.com... > TblClientID > ClientID > ClientLastName > <Client Fields As Needed> > > TblClientMember > ClientMemberID > ClientID > ClientMemberLastName > ClientMemberFirstName > <Client Member Fields As Needed> > > > TblCabin > CabinID > <Cabin Fields As Needed> > > TblBedInCabin > BedInCabinID > CabinID > BedNumber > > TblCabinRental > CabinRentalID > CabinID > ClientID > DateStart > DateEnd > > TblBedAssignment > BedAssignmentID > CabinRentalID > BedInCabinID > ClientMemberID > > Steve -- ARRRGGGHHHHHHHH !!!!!!!! -- Hey Steve !! Did you get lots of new customers from the groups lately ?? How many developers still work for you ?? This is to inform 'newbees' here about PCD' Steve: http://home.tiscali.nl/arracom/whoissteve.html (Earthlink and SuperNews kicked him out ?? ==> updated 'abuse-reporting') Until now 5950 pageloads, 3725 first-time visitors ********************************* If anyone wants to help us getting rid of Steve ?? abuse@giganews.com (appropriate action will follow when there are enough complaints) ********************************* Arno R
"John... Visio MVP" schreef in bericht news:60FD6F16-3D0F-44AB-BE27-24BB594A102C@microsoft.com... > 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... Hi John, Have you seen the recent account Steve uses? nonsense@nonsense.com Indeed, indeed! Hilarious!! He is switching accounts like a maniac (Maybe he *is* a maniac?) A while ago he used: email@invalid.com Last weeks he used: notmy@email.com Now he is switching from: emasil@email.org and email@email.org to nonsense@nonsense.com What is he trying to hide ?? Arno R
