+6I 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?
Best answer by Juliana11
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. 😊
+13Hey 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. 😊
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.