List view filter based on User relationship with Target Market database (Using Multi Select data in One field)

Hi - I can’t seem to figure out how to filter a database list based on a user field. The user field is populated using a Multi Select Dropdown and has the ability to add multiple selections in a field. For example, a User may only want to see real estate requirements in California and/or Texas…so they would check the boxes for those two states. I have a separate database named Target Markets…meaning these are the States where the user want to see real estate requirements. Is there a way to create a list view filter so User will only see requirements in the States they have added as their target markets in the related target Markets database?


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