Lookup to a lookup to a lookup

%3CLINGO-SUB%20id%3D%22lingo-sub-2574089%22%20slang%3D%22en-US%22%3ELookup%20to%20a%20lookup%20to%20a%20lookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2574089%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20trying%20to%20make%20relational%20lists.%3C%2FP%3E%3CP%3EWhat%20I%20mean%3A%20Let's%20say%20I%20have%20a%20Main%20List%2C%20this%20main%20list%20needs%20to%20lookup%20some%20data%20from%20other%20lists.%20So%20for%20example%20I%20have%20a%20field%20named%20Projects%2C%20but%20each%20project%20has%20different%20Tasks(stored%20in%20a%20separate%20list).%20So%20if%20in%20the%20main%20list%20I%20select%20a%20Project%2C%20the%20Tasks%20should%20filter%20themselves%20from%20the%20big%20list%20of%20tasks%2C%20to%20only%20the%20Tasks%20associated%20to%20the%20Project.%20Is%20this%20even%20possible%20to%20do%20with%20sharepoint%20lists%2C%20or%20should%20I%20look%20at%20other%20programs%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2574089%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2575317%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20to%20a%20lookup%20to%20a%20lookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2575317%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1109829%22%20target%3D%22_blank%22%3E%40thebigmic%3C%2FA%3E%26nbsp%3BYes%2C%20this%20is%20possible%20using%20lookup%20columns%20in%20SharePoint.%20Check%20below%20article%20for%20more%20information%20about%20lookup%20columns%20%26amp%3B%20supported%2Funsupported%20column%20types%20in%20lookups%3A%3C%2FP%3E%3CP%3E%3CA%20title%3D%22Create%20list%20relationships%20by%20using%20unique%20and%20lookup%20columns%22%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-list-relationships-by-using-unique-and-lookup-columns-80a3e0a6-8016-41fb-ad09-8bf16d490632%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ECreate%20list%20relationships%20by%20using%20unique%20and%20lookup%20columns%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20creating%20lists%20%26amp%3B%20lookup%20columns%2C%20you%20can%20show%20all%20data%20(main%20list%20%26amp%3B%20child%20lists)%20on%20single%20SharePoint%20page%20using%26nbsp%3B%3CA%20title%3D%22List%20web%20part%22%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-the-list-web-part-ef0a1b80-f8b3-443d-b04a-1e76c70b5537%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EList%20web%20part%3C%2FA%3E.%20To%20filter%20child%20list%20items%20based%20on%20selection%20in%20main%20list%20item%2C%20you%20can%20connect%20both%20lists%20on%20same%20page.%20Check%20below%20article%20for%20more%20information%20about%20this%3A%3C%2FP%3E%3CP%3E%3CA%20title%3D%22Connect%20web%20parts%20in%20SharePoint%22%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fconnect-web-parts-in-sharepoint-b457668c-d843-4b1b-8977-a6f9228a1dec%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EConnect%20web%20parts%20in%20SharePoint%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%26nbsp%3B%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%26nbsp%3B%26amp%3B%20%3CSTRONG%3ELike%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, I'm trying to make relational lists.

What I mean: Let's say I have a Main List, this main list needs to lookup some data from other lists. So for example I have a field named Projects, but each project has different Tasks(stored in a separate list). So if in the main list I select a Project, the Tasks should filter themselves from the big list of tasks, to only the Tasks associated to the Project. Is this even possible to do with sharepoint lists, or should I look at other programs?

1 Reply

@thebigmic Yes, this is possible using lookup columns in SharePoint. Check below article for more information about lookup columns & supported/unsupported column types in lookups:

Create list relationships by using unique and lookup columns 

 

After creating lists & lookup columns, you can show all data (main list & child lists) on single SharePoint page using List web part. To filter child list items based on selection in main list item, you can connect both lists on same page. Check below article for more information about this:

Connect web parts in SharePoint 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.