Create individual Value list from One Record/Field
For my invoices I'm looking to create a Value list one I enter the stye number which than looks up my products color choice field and populate a value list to the correct colors.
We are a special order dress shop and majority of our items have separate individual colors and change most seasons and I am trying to eliminate ordering the wrong color for a dress that dose not come in my color choice.
My Typical color choice record looks like (red, green, blue, black)
Some can be only made in one color and some up to 80 color.