Relational Table Occurance I think?
I have a table where I store all of my records. I have set permission levels down to the user level so that each user can only see records assigned to them. However I want to to create another layout and have all records viewable for each user and just excluded certain fields.
I went in and copied the table that all of my records resided in and related it to the original table. Then I gave the user full rights to those records instead of limited on the original records, but I cannot see all of the files. What am I doing wrong?
Please help feel like I'm in way over my head trying to figure this out