We are using DFFS 4.102 and have a need to use a lookup list on a form which is a filtered set of data.
If my list is “Accounts” with this data:
Account ID = 112, Level = 2
Account ID = 543, Level = 2
Account ID = 123, Level = 1
Is there a DFFS tool that will allow us to use a lookup list that pre-filters the available choices to just “Level 2” items?
The idea is that each user will have different access rights and we want to control which items are available in the lookup list drop down.
We are using a custom user property to set their individual “level” access right.