I need to create 2 drop-down lists site columns named security, but which contain different choices. One drop-down is used for manager sub site, while the other is used in staff sub site.
Now seems that I can not have 2 site columns with the same name. So currently I named the 2 columns as: "Manager Security" & "Staff Security". So is there a way to have duplicate names?
I have tried the following:-
I override the name at the list level. But when I add a new choice inside the column from the site collection level, its original name for example "Manager Info" will be displayed in the list again.
And of course I do not want to define these columns as list columns since I might need them on other sub-sites.
Can anyone help on solving this?