Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I've defined two list definitions and instances in a feature in VS2010.

One list only contains a required field "Employee" which is of type User.

The second list has two fields, a simple text field and a lookup field to the first list. Here's the field definition from the Schema.xml

<Field ID="{DC591BA2-D262-4810-B697-BE2E6AF64226}" Name="UserLookup" EnforceUniqueValues="TRUE"  DisplayName="Employee" Type="Lookup" Required="TRUE" List="Lists/User" ShowField="EmployeeName" Indexed="TRUE"></Field>

This works fine, and when I use new or edit forms, I get the names of the values in the first list. But in the view, the value is #ERR instead of the name. I changed it to ID and that shows fine, but the name won't show - anyone got any ideas?

Relevant schema.xml from the first list:

<ContentTypes>
      <ContentType ID="0x01006ffb64509c2341d2bff13b98859f792b" Name="User" Description="" Inherits="FALSE" Version="0">
        <FieldRefs>
          <RemoveFieldRef ID="{fa564e0f-0c70-4ab9-b863-0177e6ddd247}" Name="Title" />
          <FieldRef ID="{97666FB8-EF69-4063-924F-06E459383B7D}" Name="EmployeeName" Required="TRUE"></FieldRef>
        </FieldRefs>
      </ContentType>
    </ContentTypes>
    <Fields>
      <Field ID="{97666FB8-EF69-4063-924F-06E459383B7D}" Indexed="TRUE" Name="EmployeeName" DisplayName="Employee" Type="User" Required="TRUE"></Field>
    </Fields>
share|improve this question

1 Answer 1

The problem is using People and group column which cannot be made as a look up column in another list.

You may use a text field to do the lookup by creating a text field in the first list, and set the value to user and group field name.

Then you can use the field you created as lookup to another list.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.