Read some database design manual. Here is quick shot room table with room# as PK customer table room_type_definition table orders table (status of occupied rooms with customerID)
On Wed, 14 Nov 2001, admin wrote: > Thanks Alex > > I've ben looking around - the problem i've got is how to do the logic for > multiple room/room types against dates and customers. > ----- Original Message ----- > From: "Alex" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, November 13, 2001 5:03 PM > Subject: Re: Reservation system suggestions > > > > You could search the web. Read some books on system design. Or outsource > > the project. Anyway, narrow down your question. > > > > > > On Tue, 13 Nov 2001, webmaster wrote: > > > > > I've got a possible project coming up that would be a web based > > > reservation system for a small hotel. > > > > > > I'm banging my head against a brick wall and have no idea where to start > > > with this - has any one got any suggestions or maybe sample code that I > > > could look at ? > > > > > > TIA > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
