locked
aspx Form: Lookup should show more than one field RRS feed

  • Question

  • Hello,

    i have two Lists in SharePoint (Company and Contact Person). In the Company List I created a field (Contact ID) that is a lookup on the ID (DataBind) of the Contact Person List.

    But when I Click the Lookup Button in the company list, I can only see a list of the IDs. This is not enough Information for the user to choose the correct contact person. Is it possible in an aspx file to show more fields in the Lookup list, for example in this case the name? But to have a correct link to the contact person only the ID should be stored in the Contact ID Field of the company list.

    I had a solution, which is not the best: I created a calculated field in the Contact Person List, making a string connection of the ID and the name and added this new field to the lookup of the Contact ID Field in the Company list. In this case the Lookup shows the information I want, but the link between the data ist not correct from a database point of view. Because in the Contact ID field the ID and the name is displayed.

    Do you have an idea? Is it only possible to do this in the aspx file, or can I do this in the list itself?

    Thanks a lot and best regards,

    Michael

     

     



    • Edited by Michael9876 Thursday, November 10, 2011 8:58 AM Add information
    Thursday, November 10, 2011 8:39 AM

Answers

  • Hello Michael,

    In SharePoint 2007  this is by design behavior. In SharePoint 2010 we can add additional columns from the parent list in the child list. This is a new feature which has been added to the SharePoint 2010. The second option which you can use is the Calculated field which you are already using it .

    You can look into following articles that talks about the same in SharePoint 2010.

    How to: Create a Multiple-Column Lookup
    http://msdn.microsoft.com/en-us/library/ff717837.aspx

    SharePoint 2010 What’s New – Lookup Columns
    http://weblogs.asp.net/bsimser/archive/2009/10/19/sp2010-what-s-new-lookup-columns-spc09.aspx


    Regards,
    Manas Biswas
    Microsoft Online Community Support


    Please remember to click 'Mark as Answer' on the post that helps you or click 'Unmark as Answer' if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Monday, December 5, 2011 7:26 AM

All replies

  • Hi Michael,

    Thank you for your post.

     

    This is a quick note to let you know that we are performing research on this issue.

     

    Thanks,

    Pengyu Zhao

     

    Monday, November 14, 2011 11:48 AM
  • Hello Michael,

    In SharePoint 2007  this is by design behavior. In SharePoint 2010 we can add additional columns from the parent list in the child list. This is a new feature which has been added to the SharePoint 2010. The second option which you can use is the Calculated field which you are already using it .

    You can look into following articles that talks about the same in SharePoint 2010.

    How to: Create a Multiple-Column Lookup
    http://msdn.microsoft.com/en-us/library/ff717837.aspx

    SharePoint 2010 What’s New – Lookup Columns
    http://weblogs.asp.net/bsimser/archive/2009/10/19/sp2010-what-s-new-lookup-columns-spc09.aspx


    Regards,
    Manas Biswas
    Microsoft Online Community Support


    Please remember to click 'Mark as Answer' on the post that helps you or click 'Unmark as Answer' if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Monday, December 5, 2011 7:26 AM
  • Hi Manas,

    sorry for answering so late. Thanks for the answer. I used the calculated Field in that case, beacause modifying the list in visual studio was too time-consuming. But good to know how I do it when this point comes up again.

    Best Regards,

    Michael

    Thursday, June 21, 2012 11:15 AM