I would like to have a field (reference type) on a table that only shows a list of resources that are not referenced in other records between a date range.
Example:
Scheduling a task between Expected Start Time: 1-1-2025 08:00AM and Expected End Time: 1-1-2025 11:30AM.
- Need to assign a person to the task
- This person cannot be referenced in any other "Scheduled" tasks between the Expected Start Time and Expected End Time
- "Scheduled" would refer to the state of the task
I'm not sure if a dynamic reference qualifier is the best way to go, but any help would be appreciated.
