locked
Is there anyway to take multiple items from one list, and populate a single column in another list? RRS feed

  • Question

  • I have two lists: A and B. In list A, each item lists a product description, and then quantity (and many other things). List B is the inventory list, containing PP #s and info from each product from list A. So if an item in list A has:

    Description of Product             QTY: 4

    In list B, I will enter the 4 different PP list items, stemming from the same type product. Is there anyway I can create a column in list A that would be populated by the multiple item PP numbers from list B?

    --I just need a column in list A that contains all of the PP info from multiple items in list B, whether it be through a link, or otherwise. I just can't figure anything out.

    Friday, March 11, 2011 8:50 PM

Answers

  • You can create a SharePoint lookup column to List B and make that column as multi select. I.e.

    Create new column called PP# in List A of type "Lookup (information already on this site)", In the additional column settings, select List B for "get information from" and select the column PP# from the available columns. Once your done with the configuration, check checkbox "Allow Multiple Values" right below the In the column filed.

    SharePoint doesn't assign these values automatically. User has to select the appropriate PP# for the items in List A.

    Hope this helps.

    Thanks,


    Veera Reddy Kolan
    SharePoint Consultant
    Blog:http://veerareddykolan.blogspot.com/
    • Marked as answer by Leoyi Sun Thursday, March 17, 2011 7:54 AM
    Friday, March 11, 2011 9:34 PM
  • If I understand Bean224's requirement properly, I would create the "Lookup" column in List B, which will get information from List A without enabling "Allow Multiple Values".

    Next create a web part page and add both List A and List B. Connect both lists so that List B gets values from List A. This will allow him to select a product in List A and List B will filter automatically to show all the PP# related to List A.

     

     


    Pman
    http://www.pmansLab.com/
    • Marked as answer by Leoyi Sun Thursday, March 17, 2011 7:54 AM
    Saturday, March 12, 2011 4:47 PM

All replies

  • You can create a SharePoint lookup column to List B and make that column as multi select. I.e.

    Create new column called PP# in List A of type "Lookup (information already on this site)", In the additional column settings, select List B for "get information from" and select the column PP# from the available columns. Once your done with the configuration, check checkbox "Allow Multiple Values" right below the In the column filed.

    SharePoint doesn't assign these values automatically. User has to select the appropriate PP# for the items in List A.

    Hope this helps.

    Thanks,


    Veera Reddy Kolan
    SharePoint Consultant
    Blog:http://veerareddykolan.blogspot.com/
    • Marked as answer by Leoyi Sun Thursday, March 17, 2011 7:54 AM
    Friday, March 11, 2011 9:34 PM
  • If I understand Bean224's requirement properly, I would create the "Lookup" column in List B, which will get information from List A without enabling "Allow Multiple Values".

    Next create a web part page and add both List A and List B. Connect both lists so that List B gets values from List A. This will allow him to select a product in List A and List B will filter automatically to show all the PP# related to List A.

     

     


    Pman
    http://www.pmansLab.com/
    • Marked as answer by Leoyi Sun Thursday, March 17, 2011 7:54 AM
    Saturday, March 12, 2011 4:47 PM