This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi everyone

I have a *custom record* with two fields:

1. Field `Allowed Departments`: A list of departments. Lets say there are 3 specific departments there.
2. Field `Target Department`. A single select list of departments.
Is it possible to filter the options on Field `Target Department` to only show the departments in the Field `Allowed Departments`?

Seems like the standard way to `filter by` needs that both fields be *Multiselect* or both be *Single Select*. :disappointed: The options disappears as soon as I change the `Allowed Departments` fields to Multiselect.