For a linked field, is there a way to limit record selection to a view based on the user?
- I have a Task table, with specific tasks for specific users.
- I have a Time table, where a user selects the task
- Depending on who the user is, I want the only the tasks meant to be available.
The only way I've been able to figure it out is to create multiple linked Task fields in the Time table. Not ideal.
Thanks, David