All, how can I limit the dataset presented in linked field “drop-downs”/“pop-ups” to external form users?
Right now I have a form that allows you to select an employee via field linked to a separate table. And though I can sort that table to move inactive employees to the bottom, I cannot hide ex-employees. For that, it seems that the Linked Field needs to honor filtering, or Link to a specific view…
Can this be solved via Lookup? I’ve poked at it; but not cracked the issue.
Thanx in advance!