I have the following sheets for admins - Sheet A(admin), Sheet B(admin) & Sheet C(admin).
Sheet C(admin) was created by ‘New sheet from subtable’ via Sheet A(admin) and has link & load fields from Sheet B. So far so good and everything works great.
I want to set up duplicates for users who should have access to less fields/data for Sheet A(admin) and Sheet C(admin) so duplicated them both and named them Sheet A and Sheet C. However, on Sheet C, when I click on the link back to Sheet A it actually links back to Sheet A(admin) which I don’t want users to access. How do I change it to link to Sheet A instead?
I did try to reset the links but for some reason Sheet A lost connection with it’s parent and I couldn’t find any way to reconnect it without deleting everything and starting again.
What is the best way of approaching this please before I have another try. Should I duplicate just Sheet A(admin) to get Sheet A and then recreate a ‘New sheet from subtable’ to create Sheet C? Or is there a better way?