SharePoint List Relationships: Demo & Tutorial

[@ZEESHANUSTAD]

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

[@TechByTosh]

Thank you!

[@gnorpflorbsen8665]

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.