I have two tables: Employees and Licenses.
I created a view, named Current Licenses, on the Licenses table. This view ensures that only the active license for an employee is displayed.
I linked the Employees table to the Licenses table, specifying the view:
Unfortunately, the list of Licenses in the Employees table includes the non-currently licenses.
Am I doing something wrong?
Hey there—sorry to hear of the trouble with this! To ensure that I'm following this in full, is it the record picker list displaying the inactive licenses or is it that the field is displaying already-linked records which are inactive? The view-scoped selection applies to the menu of new records available to be added from the picker, so it's not designed to work like a view filter, hiding what's already been logged into the column's cells. If this is not quite the case here, let me know and we can dig further in. 😊
OK, I understand now.
It works as you describe.
Thanks.
That's great news! Glad to hear that this could help. 🎉
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.