I have three tables(Entities), one For Countries(This is a unique table with countries), one for the data(The data is imported from an external source into the table), and lastly one for users(contains username, email, and country).
Both the data and user are related to the country table through a lookup column of country.
What I'd want is to share the records through a portal app.
I will later invite contacts to view the records. (I would want them to view the records with regards to their countries).
I've tried researching online, but there isn't a clear way on how to relate records to contacts they have not created or directly own.
Any idea on how to achieve this will be highly appreciated.
Thanks
Knowing the contacts aren't record owners to the data table? How do I invite them in such a way that I will ensure they see only the countries they are members of.