I want to set up my form simular to how the example Northwind database is set up. In my invoice form i want a subform of products, that i can select from exactely how they do in the northwind one. So if i want several products i can just click to a new line with the new product. If i just have one product i just select one product. I am having real difficulty in setting this up. Why can't i produce a datasheet like form that lets me add from selected products rather than list them all?
THank so much if any one can help me on this.
THank so much if any one can help me on this.