Adding a table

[Julie Bright]

Im creating a database for my hotel based on the access sample template. We sell packages incl accommodation and a variety of activities based at various venues. Ive managed to get the program to calculate the cost of a package but I now need to add in the arrival date of a booking, number of guests, number of nights.

As incl with the template I am using The following tables currently: orders, order details, products, venues, i think I'm going to need a 'booking details' table with the fields 'arrival date' , 'total guests', total nights', but I can't figure out how to link this to the' order details', and/or include those details to be filled in on the 'Create New Customer Order' page.

Any ideas much appreciated.

** snip **

Thank you

[NeoPa]

Julie Bright:
As incl with the template I am using The following tables currently: orders, order details, products, venues, i think I'm going to need a 'booking details' table with the fields 'arrival date' , 'total guests', total nights', but I can't figure out how to link this to the' order details', and/or include those details to be filled in on the 'Create New Customer Order' page.

This is where you need to think critically Julie. Others can't really do that for you. If they do, then they leave you in a place where you're not in a position to take over. All I can do is ask you questions that help you to consider what the answer should be.

In what way, in your system, is a booking different from an order? Is it different at all? Are you looking to link up separate ideas, or simply realise they are two sides of the same coin?

I repeat - I cannot know the answers to these questions. I may have suspicions, but the answers must come from you alone.

Julie Bright:
Also I don't need the shipping tables/queries etc how can I delete these without screwing everything else up? I tried just copying only the items I wanted but just kept getting the message that certain bits were missing.

I've removed this from your question as we only allow one per thread. If you'd like to ask it separately then please do, but I suggest you include the relevant details otherwise we won't be able to help you.

[Julie Bright]

Thank you for your comments, in short I suppose there is no difference between a booking and an order. My concern was in trying to keep them separate to avoid duplicating dates and numbers, as a booking for a room would involve x guests for 2 nights from (say) 23 june and an activity would be booked for the same x guests for 1 day (say) 24 June and another activity for the same day etc. I guess I can add these fields to the Order Details table? Qty field could be used as 'Total Nights'?

My ultimate aim, (which I have achieved in Excel but is rather messy and needs reprogramming when products/activities change) is to be able to calculate the cost of a package (room and activities). Create a booking with those details, with confirmations/purchase orders going to suppliers, and an Itinerary for customers detailing when and where they need to go for activities.

[NeoPa]

Again, I'm left without the full knowledge of all your thinking and requirements (which is good - I don't want to be doing this for you anyway.), but do all room bookings necessarily cross with activity bookings? If not, then perhaps you need an Order table, which simply manages overall orders, and a separate OrderDetail table that handles items of multiple types. One might be a Room item, and others might include Activity items. Exactly how it's stored depends on the critical thinking that you, as the only person who really can, have done to decide how everything best fits together. It may well be that Room items can be considered as parents of the Activity items. It all depends on exactly what you need.