When we add a linked record field to our base, we have the new option to “limit record selection to a view” in the other table.
This is fantastic.
HOWEVER — the gigantic problem with this is that whatever option we make for “limiting record selections” applies to our ENTIRE CURRENT TABLE.
We can’t change this option on a view-by-view basis. This option applies to every single view in our current table.
In other words, we have no ability in our current table to create 2 different views:
- View A uses a linked record field, but we only want to show a certain set of linked records to choose from.
- View B uses that exact same linked record field, but we want to show a DIFFERENT set of linked records to choose from.
This dramatically limits the usefulness of this feature for us, because we have no ability to limit our linked record field to DIFFERENT RECORDS based on DIFFERENT VIEWS in our current table.
In other words, this option is attached to the “field definition” itself, instead of allowing us to change this option on a view-by-view basis.