selective list

[aman909]

Hello,

I have a stock control system for fabric that is produced. The stock control has contains details of every colour of fabric that is produced. We have about 40 to 50 different colours.

Im now adding a ordering processing system to it as well. In this order system we have certain clients that only ever order certain colours. For example one client will only ever order 5 colours we produce.

I would like to produce a form, which only finds stock details for only certain colours depending on the client. So i need some sort of selective list.

For example Client A only ever orders red, black and blue. So i would only like to be able to see those stock levels for those colours, not all the colours.

How do you suggest the best way to do this?

 

[ColinEssex]

Just thinking about this quickly - (and there may be a better way)

You need to identify the clients that always have the same colours, as opposed to those who have only had say one order. A TickBox would identify these clients.

Next, you need to select the colours they always have, I would suggest a maximum of 5 ComboBoxes on a tab of the clients form. You can then select the colours from your list.

Then you need to set up a count of those colours from the current stock list and display it when you select that client. The TickBox (above) will indicate if this calculation is to happen or not. You'll also need to exclude the ComboBoxes that are empty (Null) like, if you have 5 Combo's and only 3 have a value.

Hope this helps get you started - someone else may have a better way perhaps

Col