Hi Shiran! If you’d like to share the student data with someone that only needs partial access:
(1) Create a view for that user with unnecessary records filtered and columns hidden. If you’re ok with this user also being able to unhide that data, you can stop here.
(2) But if you’d like to restrict their ability to look beyond that view, then create a share link. The downside is that share links don’t permit editing since any user with edit permissions can see all data in the base. But you also won’t have to pay for this user.
As for linked records, I don’t think they’ll help you here. It’s definitely possible to create one to one relationships, but you wouldn’t be preventing anyone from accessing data in the other table. Users could just as easily click the other table and poke around. In other words, it’s no different than (1), the user is just clicking a table rather than a view. But it’s a poor substitute for views because it introduces data redundancy. Here’s a previous discussion related to adding additional tables. Best of luck :slightly_smiling_face:
