Not sure if this is possible but wanted to run it by the group.
I have a value list labeled Companies which is set to "Use values from field: Companies::CompanyName".
There are multiple fields on a layout where the user would like the drop down to be a list of Companies based on their type, for example:
FieldA - drop down of only companies where the company type = typea
FieldB - drop down of only companies where the company type = typeb
Is this possible?