| Usama Ashraf
How to Configure or Create Relationships between Tables
Part I
Relationships established between the tables. Relationships are used to get the data from two tables.
Tables that relate with one another have a relational connection. Relationships established a relational database that is managed by Microsoft.
Currently in Dataverse we have following three types of relationships exist but two are used most commonly:
- One-to-Many (most commonly used)
- Many-to-One
- Many-to-Many (most commonly used)
One-to-Many:
In this type of relation, relationship work as a Parent-Child relationship. For understanding this relationship let us consider an example of Student, Course and Enrollment table. One Student can Enrolled in many courses and due this Courses can also have one-to-many relationship with Enrollments.
One-to-many relationship can also create automatically between two tables when you add a lookup column of one table into another. It means you added a Student field with lookup type in Enrollment table and this lookup type field will create a one-to-many relationship between Student and Enrollments.
Many-to-Many:
For Many-to-Many relationship we need another table called Bridge/Intersect table that contain records of both relational table. Like if many Products can have many Customers and many Customers can have many Products. So for handle this relationship we need Bridge table.
We will discuss the creation of relationships in our next Blogs and will learn in detail with each and every step.
Join us next time, as we continue our journey of learning canvas apps.Click here to learn more about Imperium's Power Apps Services. We hope this information was useful, and we look forward to sharing more insights into the Power Platform world.
