Multiple Orders Form

[Stemdriller]

I thought I was getting the hang of this database thing, however........

Trying to create an orders form. User can select a Product from a drop down and if they just want the 1 product thats ok, but when they want to order 2 or 3 different items on the same order number I have major issues.

Any guidance would be very much appreciated.

 

[Stemdriller]

Uncle Gizmo,

Thanks for responding. I have got a bit further, but come up against other issues. I do believe it is something simple that is causing it.

I have attached the DB hoping that you could cast your expert over it.

frmOrders - Currently allows you to select a customer
Sub Form frmCreateOrderNumber allow your to create a
unique order.

Trying to insert frmSelectProducts which allows the user to select single or multiple products, but keep getting an error.

Your help or advise would be greatly appreciated.

Stemdriller