Elephant
Registered User.
- Local time
- Today, 06:41
- Joined
- Nov 22, 2002
- Messages
- 52
I am developing a database for a travel company.
I have a form called "Orders" with general details about customer and a "OrderID". A sub-form to this is "Order Details" listing the various itmes of the order, ie hotel stays.
In the "Order Details" sub-form I want to put the Supplier name (ie, hotel name), the room type (eg, single, double etc) and then put in the Dates of stay (Arrival date, Departure date or Arrival date and number of nights stayed) - then I want the price to be automatically calculated and displayed.
One important issue is that over a given period of stay (eg June 4th, 4 nights) some nights can be "Price X" and some "Price Y" depending on the day of the week so the solution must take this into account.
Any ideas how to make this work?
Thanks
Steve
I have a form called "Orders" with general details about customer and a "OrderID". A sub-form to this is "Order Details" listing the various itmes of the order, ie hotel stays.
In the "Order Details" sub-form I want to put the Supplier name (ie, hotel name), the room type (eg, single, double etc) and then put in the Dates of stay (Arrival date, Departure date or Arrival date and number of nights stayed) - then I want the price to be automatically calculated and displayed.
One important issue is that over a given period of stay (eg June 4th, 4 nights) some nights can be "Price X" and some "Price Y" depending on the day of the week so the solution must take this into account.
Any ideas how to make this work?
Thanks
Steve