Coldfusion Reservations Site

I am familiar with access and coldfusion and how they interact.  I would like to figure out how to setup a site that people can make reservations on.  The database would have a set number of reservations and a waitlist that would open once the reservations were maxed.  Any guidance?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

James RodgersWeb Applications DeveloperCommented:
yes - first dump access
access is ok for testign and for single user or a maximum user group of 5 connections after that the usability deteriorats and access is memory intesive and expands to consume more harddrive spce with every read/write, use oracle or sql, if you don't have the money then get mysql, its free.

next database design
you need to normalize all your data in order to reduce redundant data being carried in multple tables, if you are not familiar with data normalization then you will need some help, this is a big part of making data storage and reteival easier

tables - off teh top of my head
Members - you will need some kind of members or user list to track the major details of the site users, the kind of info you gather will depend on your site needs,
memberid (pk), lastName, firstName, email, address, phone ... you get the idea

resid, typeid, locationid, maxreservations, costper (maybe, only if cost per reservation is fixed), closeDate

resid, amenityId

amenityId, amenityDesc

memberId, resId, dateResMade (inc time), deposit (y/n), depositType(cash, cc etc.), depositAmount

resType (used if you take multiple reservation types, air, bus, train, hotel, restraunt etc.)
typeID, typeDesc

like i said just off the top of my head, without having more details it would be impossiblre to properly desing a database

once the db is designed the input output is easier to design and implement

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bjv211Author Commented:
ok so i'll look into mySQL and get back to you, thanks for the start.  Oh sorry not to specify that this is a reservations site for tickets at a play theater.  So the info collected would be name address phone email quantity date of performance.  There would need to be a maximum of tickets reserved and then once those are filled, a waitlist.  In any case i'll try to get mySQL since you say that Access will be too much for multiple users.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.