With forms, I created a subform in my Order Form.
In my form i have customer information, and in my sub form i want to have the products which the customer wants to order.
So in my subform i will need Product Name, Brand, Quantity and Price. I designed the subform using wizard, however there are no values. Do i have to create a Query so if a customer orders a product e.g. Product Name: Pentium 4, the brand name, price will automatically come up.
Also how would i make it so customers can order multiple products, not just one?