Problems with Lookup feature

[JimmyG]

My database contains an Orders form from which the user can select the customer who is placing the order via a lookup. The database also contains a Product form from which the user is able to select the customer, using a lookup, and enter the product name. Products are exclusive to individual customers so each product is assigned to a customer.

The Orders form contains a subform which is used to enter order details, this is where my problem occurs. At present the subform contains a lookup from the products table which lists every item we produce. The situation at my company is that product ranges are exclusive to individual customers as mentioned i.e. no two customers will order the same item. It would therefore be useful if I could limit the drop down list on the subform to only contain those items which are available to the customer selected from the main form.

Is this possible? Another problem is that we also stock two items which are standard and therefore could be ordered by any customer.

I guess that the way to make this possible would be using a query, so have posted the problem here.

I appreciate any help....

 

[aleb]

Can you post a db?

 

[JimmyG]

I've simplified my database as much as possible to reduce the file size

The database should open on the Orders form, where the problem occurs. As you'll see when you click on the drop down box in the subform all labels are listed. Ideally I would like only those assigned to the customer selected in the main Orders form.

Thanks for any help

 

[aleb]

If you can wait till 20th I will post a full blown version of the stuff you trying to accomplish.
I am just out of my office till that moment.

 

[JimmyG]

Cheers Alexei,
I've got no problem with waiting till you are free

Thanks for all your help
Jim

 

[aleb]

Here is the version. There are examples of treeview usage, listview usage, multiple selection in listview, examples of custom menus, toolbars.
I had to strip db from some functions to fit allowed size. It is twice packed first it is packed with RAR then with ZIP.
In orders forms when you selected the customer you can make a multiple selection in product list, hold down CTR and click on products. then click create order,