Linked Records Filtering Condition Not Working

Not sure what exactly you are trying to achieve but your table structure seems very off.

You should always have one table for one type of record. Creating separate table for each category isn’t the right design. Create one table called Category where different categories will be different rows or records in that table. Whatever details you need to store about each category, add that as column in the Category table itself.

Then in your Contacts table, instead of using a single select field for category, crate a Linked Record field for Category linking it to Category. You should not be duplicating data by having a separate single select field and Category table for the same thing.

And now, you can create a filtered view in Contacts table setting the condition to Category being XYZ.

The main contacts table acts as a master sheet for all our contacts while each category of contacts has their own sheet where I can deep dive into details. The structure is actually sound, but maybe I am applying it wrong. I’ve attached screenshots to make it clearer - my only issue now is that the linked record is not adhering to the filtering condition. As you can see, “Test6” is marked as “Press” yet it is still showing up in the “Celebrities” table where I specified a condition where category = stylist

​@ritamzhr I tried what you have described and it seems to be working as expected. Just ensure that your filtered view in Contacts table is correctly configured to show only Stylist.

Also, if your Stylists view is showing only Stylist contacts, you don’t need the other filtering condition as that is redundant. 

Hm, I’ve set up an example of filtering the linked records here for you to check out

Once we set the filter condition, when we try to link a record it only shows us either the ‘Press’ or ‘Stylist’ records:

Do note that adding a filter to a linked field like this has no effect on data that already exists in the linked field, this functionality only affects the records that are available for selection moving forward