Link entries from List B to List A, using primary key

%3CLINGO-SUB%20id%3D%22lingo-sub-315283%22%20slang%3D%22en-US%22%3ELink%20entries%20from%20List%20B%20to%20List%20A%2C%20using%20primary%20key%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-315283%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20SharePoint%20lists%2C%20with%20the%20following%20columns%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EList%20A%3A%3C%2FP%3E%3CUL%3E%3CLI%3EClient%20Name%3C%2FLI%3E%3CLI%3EClient%20Address%3C%2FLI%3E%3C%2FUL%3E%3CP%3EList%20B%3A%3C%2FP%3E%3CUL%3E%3CLI%3EClient%20Name%3C%2FLI%3E%3CLI%3EProject%3C%2FLI%3E%3CLI%3EStart%20Date%3C%2FLI%3E%3CLI%3EEnd%20Date%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20relationship%20between%20these%20lists%20is%20one%20to%20many%20(A%20to%20B)%20-%26nbsp%3BWhile%20List%20A%20has%20a%20list%20of%20unique%20clients%2C%20List%20B%20has%20numerous%20projects%20for%20one%20or%20more%20clients.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20of%20displaying%20all%20entries%20in%20List%20B%20in%20each%20record%20in%20List%20A%2C%20where%20the%20'Client'%20values%20match%3F%20For%20example%20-%20if%20List%20B%20has%205%20projects%20in%20it%20for%20'Client%201'%2C%20each%20of%20these%20projects%20display%20when%20'Client%201'%20is%20opened%20in%20List%20A.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-315283%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-323528%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20entries%20from%20List%20B%20to%20List%20A%2C%20using%20primary%20key%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-323528%22%20slang%3D%22en-US%22%3E%3CP%3EWell%2C%20SharePoint%202013%20only%20supports%20classic%20list%20views%20and%20it%20will%20look%20like%20this%20with%20out%20of%20the%20box%20list%20view.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F70548i407808B60A18B0A3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22list.PNG%22%20title%3D%22list.PNG%22%20%2F%3E%3C%2FSPAN%3ESo%20you%20need%20to%20modify%20the%20list%20view%20(with%20SharePoint%20Designer%20possibly)%20or%20build%20data%20displaying%20solution%20on%20a%20page%20with%20web%20parts.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321538%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20entries%20from%20List%20B%20to%20List%20A%2C%20using%20primary%20key%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321538%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20exactly%20what%20I%20need%20-%20I%20have%20tried%20to%20do%20this%20but%20failed%2C%20how%20do%20I%20achieve%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20answer%20to%20your%20questions%2C%20'Client%20Name'%20is%20listed%20on%20List%20B%2C%20and%20I'm%20using%20SharePoint%202013.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-319253%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20entries%20from%20List%20B%20to%20List%20A%2C%20using%20primary%20key%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-319253%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20about%20creating%20a%20Lookup%20field%20to%20List%20A%2C%20which%20connects%20to%20List%20B%3F%20With%20lookup%20column%20you%20can%20link%20items%20from%20List%20B%20to%20a%20column%20on%20List%20A%20and%20select%20which%20List%20B%20columns%20are%20displayed.%3C%2FP%3E%3CP%3ESomething%20like%20this%20as%20an%20example%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68749iAA6EF562C1824282%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22list.PNG%22%20title%3D%22list.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EDo%20you%20need%20to%20display%20Client%20Name%20on%20List%20B%3F%3C%2FP%3E%3CP%3EIs%20this%20on%20modern%20or%20classic%20SharePoint%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable

I have two SharePoint lists, with the following columns:

 

List A:

  • Client Name
  • Client Address

List B:

  • Client Name
  • Project
  • Start Date
  • End Date

 

The relationship between these lists is one to many (A to B) - While List A has a list of unique clients, List B has numerous projects for one or more clients.

 

Is there any way of displaying all entries in List B in each record in List A, where the 'Client' values match? For example - if List B has 5 projects in it for 'Client 1', each of these projects display when 'Client 1' is opened in List A.

 

Thanks

3 Replies
Highlighted

How about creating a Lookup field to List A, which connects to List B? With lookup column you can link items from List B to a column on List A and select which List B columns are displayed.

Something like this as an example

list.PNG

Do you need to display Client Name on List B?

Is this on modern or classic SharePoint?

 

 

Highlighted

This is exactly what I need - I have tried to do this but failed, how do I achieve this?

 

In answer to your questions, 'Client Name' is listed on List B, and I'm using SharePoint 2013.

 

Thanks

Highlighted

Well, SharePoint 2013 only supports classic list views and it will look like this with out of the box list view. 

list.PNGSo you need to modify the list view (with SharePoint Designer possibly) or build data displaying solution on a page with web parts.