Trying to create a conditional value list without relationship
I am trying to create a conditional relationship without relationship.
What I am working is:
User table with username and department
I would like to create a username value list depending on user's department (i.e. Sales, or CustomerService, IT, etc)
If I create a global field with calculations (- Define a calculation field that only returns a value if other conditions are met and base your value list on this field instead of the original data field.), how can I create a list out of the calculation?