Duplicate records in a linked field

Hey Guys! Is there a way to do a unique setting for linked records. I only see ways to filter by empty/not empty and Contains/does not contain. I want to say, link to this field, unless value is already present. This will avoid duplicates in my linked field.

You can’t enforce it, but you can limit which records visually appear in the popup menu for the linked record field by choosing which view in the linked table it should pull its records from.

So you could create a view in the other table that is filtered to only show you records which haven’t yet been linked, and then change your linked record field in the original table to only show you records from that view.

Thank you. How do I create that new view? Will it also work when using the Search App?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.