Can a script be used to select a specific "Value List"?
I have 2 Tables
A Manufacturers Table and a Products Table.
In the Products Table I have a "Product Group" field that I would like to be from a drop down value lists that is specific to the Manufacturer of the product.
I was thinking that a script could do this. That script would be activated via a script trigger in the Products Table that once the Manufacturer (and that Manufacturers Unique ID) was selected it would state use the "Product Group" Value List associated with that Manufacturer.
Is this possible or am I thinking of this in a incorrect manner?
If it is possible are there any existing examples of a script too use?