Relate list of colours to unique product id

[jsrdixon]

Hi.

I want to select a product then be able to select a colour from a list that relates to it.

I want the colour lists to be different for every product. (clothes)

Whats the best way to do it?

Thanks

Jonny

 

[GaryPanic]

you are limited by the color pallet in Access - its not the greatest selection
and if this is what you are after - check samples on this - already been done
g

 

[jsrdixon]

I dont a colour palatte

i need to enter in my own text colour values.

any ideas?

 

[GaryPanic]

check cascading combo - on either the serach or samples

 

[Simon_MT]

Try putting the color into the product code and then in a module

Function SetStockColour

With CodeContextObject
.[Whatever].ForeColor = .[StockColor]
End With
End Function

Or better still have a photograph of the Clothing on your screen.

Simon