2 Sharepoint list relation with lookup column and restrictions

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