Hello!, first time posting in the community!
Is there a way to filter a choice list based on the result of another query? I have a choice list that I currently filters via a reference qualifier. However, for each entry in the choice list, I'd like to exclude those that do not have a relationship to another table.
For example, let's say the choice list references sys_user that currently filters based off of org + status and a custom table that is a table of SMEs (fields being Area of Expertise/Company/User). I would like the choice list to only allow users that's part of the SME table.
Thoughts?
