Creation and Enforcement of Relationships [Dataverse Relationships Part 1]

In this video, you'll learn about how to create relationships between different tables in Dataverse and the different types of advanced relationship enforcements you can create to prevent users from deleting the wrong records. You'll see the different referential, custom and parental relationship types in Dataverse and how it will impact your Power App. This video series contains information needed for the PL-100, PL-200 and PL-400 certification exams.
Part 1: Creation and Enforcement of Relationships: • Creation and Enforceme...
Part 2: Hierarchy Relationships: • Hierarchies and Self-J...
Part 3: Many to Many Relationships and Relate and Unrelate: • Many to Many Relations...
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/

Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️CZcams: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]
~-~~-~~~-~~-~
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
• Free Power Apps Compon...
~-~~-~~~-~~-~

[@sueamin2788]

Hi Brian: Thank you for this very timely and succinct video series. I have a large Portal Form with five subgrids for repeating tables and multiple file uploads each with defined metadata with SP integration. Understanding the relationships will help us take the correct steps in the beginning. Your series of Tutorials have helped me tremendously. Many thanks for your trainings.

[@PragmaticWorks]

Thanks so much! - Brian

[@SecretPles]

Thank you for detailed explanation !

[@PragmaticWorks]

You're welcome (:

[@jourdan6947]

Thank you for this!!

[@PragmaticWorks]

Thanks for watching! :)

[@guerreirodancante]

YOU SAVED MY LIFE

[@PragmaticWorks]

Glad to help (:

[@antonypbsilva]

Hi Brian. How could we create a composite primary key in a dataverse table?

[@reileybergin5833]

Hi Brain. Thank you. Quick question that I think will be helpful for others. Do you know if it's possible to set the custom settings so that the parent row can be deleted without removing the lookup value in the related rows? From what I can tell I can only chose from the three options; Cascade All (delete both the child row and lookup value, not what I want), Remove Link (remove the lookup value for all related rows, not what I want because I want to keep this intact), or Restrict (prevent the primary table row from being deleted when related table rows exist, again not what I want because I don't mind if this is deleted as long as the lookup value stays intact). Any thoughts? Thanks so much.

[@jankucera1512]

Hi Brian, first of all thank you for very good tutorials. Really helpful. I have a question if it is possible to have nested forms. We have two tables which are related. ActivityID from Activity table is realated to many in LOtable. We need to see the list of Activity ID and by selecting one of them go to the list of associated records from the child table (LOtable) and edit those one by one. Any idea?
thanks

[@stevengarcia7277]

what is the best option if I want to create a relation between products and categories, cause I was thinking to create a autonumeric as a primary key, but I´m confused with the lookup type

[@LandscapeInMotion]

Nice demo! Why is that a child record can only be associated with one parent? Is there a way around that?

[@anacarolgomesr]

I cant understand how the two tables are linked. Which columns are beeing checked as equals to creat a relationship?

[@diamondunbreakable3257]

why do you have to draw the tables?. There should already have a visual for that just like in powerBI, Access etc

[@PragmaticWorks]

That diagram type visual is not available in Power Apps / Dataverse.