Filter Form "Drop-Downs"/"Pop-Ups" to Omit Data


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!

split this topic #2

2 posts were merged into an existing topic: Filter data for linked fields

closed #3