for each order show all products?

[pinstripe]

Hey,

i use nwind from microsoft which suits me fine with this project, just with one small difference.
I need to show for each order all products instead of picking one by one up from combo box.

So this means, i need to show something like continious subform, always with all of the products listed. Of course for each order different products are ordered so it has to be linked by orderID somehow.

How can i do this?

 

[pinstripe]

anybody?

any suggestion?

 

[kjohnson]

You may not be getting any help, because it isn't access

 

[pinstripe]

no, nwind is NorthWind access database which is generally distributed by microsoft (you can get it for free from microsof web side; and also use it for free)
anyhow;

in access i have a main form (Orders) and subform (Products) (it is many to many relationship). What i would like to do is to always show ALL products from database for each order (not just the products that were ordered but every single product availabe)!
they are linked by OrderId with master and child
The purpose for this is that user get's whole preview of product (not to search one by one from the combobox); and then enters quantity for ordered product.
I don't know how to show all records of products for every order!

Hopefully this is clear now, if not, please don't hesitate to ask. Thanks