I have a list of students in my ‘home’ table but I need a separate table for some of these students that have extra requirements (I’m aware I could have it all in the same table and just filter/group/sort but I’m looking to share this separate table with people who only need access to the extra students and not the others.
How can I link the records (first column is Names of the students) between the two tables so I can add Lookup columns for the relevant info I do want to share in the separate table?
Been trying to figure this out for a while and couldn’t because it’s not a relationship between two different records but the same one, just in another location. Any help is appreciated!!