2 Sharepoint list relation with lookup column and restrictions

%3CLINGO-SUB%20id%3D%22lingo-sub-2434915%22%20slang%3D%22en-US%22%3E2%20Sharepoint%20list%20relation%20with%20lookup%20column%20and%20restrictions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2434915%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20following%20scenario%20im%20trying%20to%20make%2C%20i%20know%20you%20cant%20make%20column%20permison%20level%20on%20sharepoint%20list%2C%20but%20is%20it%20possible%20to%20make%202%20lists%20where%20on%20the%20second%20list%20i%20only%20give%20acces%20to%20certain%20users%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3EList%20Contracts%20(public%20information)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EID%20%7C%20CONTRACT%20%7C%20contract_duration%20%7C%20%3CSTRONG%3EID_COST%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EList%20Costs%20(Sensible%20information)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EID%3C%2FSTRONG%3E%20%7C%20contract_cost%20%7C%20company%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20then%20i%20give%20access%20to%20most%20people%20to%20list%20of%20contracts%20only%2C%20but%20for%20the%20costs%26nbsp%3Blist%20since%20it%20is%20restricted%20information%20i%20only%20give%20acces%20to%20very%20few%20people%20i%20control.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20and%20i%20hope%20my%20question%20was%20clear%20enough.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2434915%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20List%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2435932%22%20slang%3D%22en-US%22%3ERe%3A%202%20Sharepoint%20list%20relation%20with%20lookup%20column%20and%20restrictions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2435932%22%20slang%3D%22en-US%22%3EIt%20seems%20this%20can%20be%20achieved%20through%20Item%20Level%20permissions.%20You%20can%20find%20a%20really%20good%20info%20on%20the%20same%20here%20-%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsharepointmaven.com%2Fhow-to-enable-item-level-permissions-in-sharepoint%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsharepointmaven.com%2Fhow-to-enable-item-level-permissions-in-sharepoint%2F%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fblog.netwrix.com%2F2019%2F03%2F07%2Fhow-to-use-sharepoint-item-level-permissions%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblog.netwrix.com%2F2019%2F03%2F07%2Fhow-to-use-sharepoint-item-level-permissions%2F%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.about365.nl%2F2018%2F07%2F30%2Fhow-to-properly-make-use-of-item-level-permissions-in-sharepoint%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.about365.nl%2F2018%2F07%2F30%2Fhow-to-properly-make-use-of-item-level-permissions-in-sharepoint%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello guys,

 

I have the following scenario im trying to make, i know you cant make column permison level on sharepoint list, but is it possible to make 2 lists where on the second list i only give acces to certain users? 

 

Example:

List Contracts (public information)

ID | CONTRACT | contract_duration | ID_COST

List Costs (Sensible information)

ID | contract_cost | company 

 

And then i give access to most people to list of contracts only, but for the costs list since it is restricted information i only give acces to very few people i control.

 

Thanks in advance and i hope my question was clear enough.

1 Reply