I have a table, called Sites. This table is restricted for users and users could only access Sites they have permission to.
I have another table, lets call it Child Sites. A Site could have many Child Sites. Child Sites is just a link between two different Sites, and a Child Site Name is just a Site Name.
The issue is, since users are restricted by the Site, they can't access the Child Site Name since that is just pulled from the Site table. I would like users to have permissions to just the Site Name itself so they could see a Child Site Name, but I am having issues doing it.
I tried to create a Formula Field in Child Site that equals Site Name. This is still not showing I'm guessing since it's pulled from the Site table directly.
Is there a way to either:
1. Make a new field that automatically populates from the Site Name in Child Site without DIRECTLY pulling from Site Name since that is restricted?
2. A way to make just one field accessible for every user on a table they do not have access to?
------------------------------
Mike Savan
------------------------------
