Problem Creating an Order Basket Form

[manager00104]

Hi,

Can anyone show me how to create an order basket form in Microsoft Access 2010 ?

I already have my Order table, but dont know to set up the buttons and the lay-out of the actual combo box ?! Or "take from the add existing fields" ?

If someone could help me with this it would be so helpful, for my coursework !!!

Thanks,

manager00104,

ps: there are some attachments listed below for some ideas on how to change and alter things :S ?!

 

[PNGBill]

I suggest you do not leave spaces in field names. Serves no purpose except to make typing harder. OrderID is better then Order_ID.
Unless your lecturer thinks otherwise....

By Order Basket do you mean a way of holding the goods on order before the sale is completed ? or just the layout of the forms?

In the table, you could have a field OrderStatus and this wuld be OnOrder, DeliveryDocket or SalesJournal eg. The word denotes the status and you are then able to Select from the data as required. The record would be updated as the status changed.

The Forms..
You would normally have a main form being the header which would hold the data basicly as frmOrderBasket is.
You then have a subform (continous) which would hold the items on order.
The link is the OrderID field.

The subform is bound to the table that holds the goods on order.

Trust the above isn't confusing.