Forum Discussion
Multiple sharepoint lists sharing same columns
Hi, thanks for your repsonse.
So what I want to do is have 3 listst that share some of the columns and each has its own set of columns. The first column (column 1) would be a unique column.
LIST.A: Column1(unique) Column2 Column3 Column4
LIST.B: Column1(unique) Column4 Column5
LIST.C: Column1(unique) Column2 Column4 Column6
In fact it's list level security. It's just that the lists are shareing the same entries just with some same and some different columns involved.
Ok so what are my possibilities for this problem? Cheers
Do you have a requirement there for security or is it that you just want to show different data sets to different users? If there's no security requirement around it, you could just use a single list with different views configured for each group of users. This way you have one version of the truth, i.e. one list item which is accessed by several different groups of users, but depending on the view will depend on the columns which are shown. This approach would give you the following:
List:
VIEW.A: Column1 Column2 Column3 Column4 Viewed by users set.A
VIEW.B: Column1 Column4 Column5 Viewed by users set.B
VIEW.C: Column1 Column2 Column4 Column6 Viewed by users set.C
Hi,
thanks for replying. Unfortunatelly, I need this for security. So group of users need to have access to list A, others need to acces List B etc.
