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.