wort0987654321
Registered User.
- Local time
- Today, 11:09
- Joined
- Dec 5, 2002
- Messages
- 90
i am making a car rental database.
the ordering process goes like this:
1. a customer form opens to enter their details
2.they click next button (made from macro)
3. this then opens a different form where the customers id and name are selected from a drop down menu, the staff id and name is also selected, they must then enter the date to and from they would like to rent a car. they can then slect a car from a combo box.
4. they click next again.
5. (this is the bit i cant do) i want this to open a form which will allow the customer to rent extras with their car (bike rack, booster seat, ski rack, child seat). i would like them to be able to select the quantity of each of the items that they would like. i dont mind if this form has a subform on as long as all of the information leads back to my main rentals table.
any help would be much appriciated as i have tried for hours to do this ith no success.
the ordering process goes like this:
1. a customer form opens to enter their details
2.they click next button (made from macro)
3. this then opens a different form where the customers id and name are selected from a drop down menu, the staff id and name is also selected, they must then enter the date to and from they would like to rent a car. they can then slect a car from a combo box.
4. they click next again.
5. (this is the bit i cant do) i want this to open a form which will allow the customer to rent extras with their car (bike rack, booster seat, ski rack, child seat). i would like them to be able to select the quantity of each of the items that they would like. i dont mind if this form has a subform on as long as all of the information leads back to my main rentals table.
any help would be much appriciated as i have tried for hours to do this ith no success.
