SharePoint List Relationships: Demo & Tutorial

Create list relationships between SharePoint Lists or Microsoft Lists. You will learn how to create the relationship between different SharePoint Lists by creating look up columns and joining two lists.

We will be looking at creating a Supplier / Order list, so that the list can capture different suppliers and product orders for those suppliers. We will learn how to avoid adding the repeated information manually and how to make better manage multiple lists in SharePoint and Microsoft Lists.

Make use of Lookup columns in SharePoint lists to join different lists and create cascading effects on item updates/deletions.

▬▬▬▬▬▬ Enroll in my SharePoint Course at UDEMY 🚀 ▬▬▬▬▬▬
Course: SharePoint Online: Complete Guide to Microsoft SharePoint

▬▬▬▬▬▬ C H A P T E R S ⏰ ▬▬▬▬▬▬
0:00 Introduction
0:36 Understanding SharePoint List Requirements
1:20 Common Mistakes When Capturing List Items
3:10 Creating & Understanding Supplier List
6:47 Creating Products SharePoint List
8:14 Understanding Supplier/Product List Relationship
9:10 Create SharePoint List Relationship Between Supplier & Products
12:31 Creating Lookup column and adding related columns
13:10 How to Keep Lists Consistent (Update/Delete Items)
18:03 Adding Suppliers against Products (Many to Many Relationship)
21:15 What does Consistency Mean in SharePoint List Relationships?
23:17 Managing Permissions for Connected SharePoint Lists
24:10 Wrap up

▬▬▬▬▬▬ Want to learn more? 🚀 ▬▬▬▬▬▬

🎬 Movavi Video Suite To Create YouTube Shorts or Edit Videos

🔔 Subscribe for more tips just like this:

▬▬▬▬▬▬ 🔥🔥 VIDEO CREATION PRODUCTS I USE 🔥🔥 ▬▬▬▬▬▬

🚀 SOCIAL
===============================
🤝 Connect with me

As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.

#techbytosh #SharePoint

[ZEESHANUSTAD]

What an explanation!!. Very easy to understand the relationships . Thanks Dear.

[gnorpflorbsen]

This is great but, quick question:
Maybe I missed it, but my this doesn't align with my understanding of many to many relationships.
I need to see the associated entries and create relationships from either list without knowingly/directly/manually interacting with a join table.
- If I were to look at the Suppliers list I would want to be able to select a Supplier row and view the associated Products.
- If I were to look at the Products list I would want to be able to select an Product row and view associated Suppliers.
- From either list I should be able to associate one or more items from the related list and then it the association should be immediately/dynamically visible on the other list.
- If a lookup / join table is used the users shouldn't need to interact with that list.

Is this possible? What is best practice for that?

[KritaNinja]

that is NOT a many to may relationship.