Using 2 different ValueLists for one Field
I have a quick question to ask, well I think it is a quick question. Is it possible to have a feild display 2 different value lists? What I mean is, in my solution I have a field that when a certain value is set it calculates a table to get values to populate a dynamic value list. Now I need to find out if there is a way to display a static value list in the same feild should the other option be selected.
So in a nutshell:
If Field A is selected with option 1, then run script to sort table and get values to populate in ValueList A that is used in Field B.
If Field A is selected with option 2, then Field B uses static ValueList B
I was thinking of duplicating the layout and then just switching between layouts depending on the value in Field A and then depending on the layout would depend on what ValueList is set for Field B. Would this be the easier option or is there a better way to do this?