In my portal I have two lists. One (we'll call it the people-list) is a list of people's first and last names and their username (person column) if they have one.
I have created a content type that contains a lookup column that lets you choose the
Last Name from the people-list, and also loads the
Now, I have a second list that uses this content type.
My problem is that I want to create a view that displays only items where the current user is equal to the username of the people-list.
But when I created the content-type (all through the web-GUI), there was no option to choose the
username column. So I can't seem to get a handle on the username from the people-list, even though I do have the
Last Name from that list (and the username is on that list).
How can I do this (Sharepoint Server 2010 Enterprise)?
Now, I considered using a Calculated Column with this formula:
But the problem is that since
Last Name is derived from a lookkup column, I can't use it to calculate anything!