cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alan2022
Frequent Visitor

What is the Table Structure of Master Detail One to Many Relationship?

Hi Community,

 

Im planning to create a master detail in powerapps. But im confuse with the table structure.
Is my table structure is correct? Thanks

Table Name - Project
Column1 - ProjectID (AutoGenerated) (Number)

Column2 - ProjectName (String)

Table Name - Employees
Column1 - EmployeesID (AutoGenerated) (Number)

Column2 - ProjectID (Number) 
Column3 - EmployeesName (String)

Relationship Key: Department->ProjectID - One to Many - Employees->ProjectID

1 ACCEPTED SOLUTION

Accepted Solutions
Fubar
Solution Sage
Solution Sage

One-to-many relationships is a Lookup field i.e. you create a Lookup field on the child record where the Lookup field is of type <Parent entity>.

 

Internally this relationship is via the internal GUID (system generated) of the parent record, but for display purposes shows the value of the "name" field of the parent record.

 

E.g in your example the minimum you would create of a one-to-many would be 

Project

  • Name

Employee

  • Name
  • Lookup (Project)

(and any other fields you want on the respective entities)

 

View solution in original post

2 REPLIES 2
Fubar
Solution Sage
Solution Sage

One-to-many relationships is a Lookup field i.e. you create a Lookup field on the child record where the Lookup field is of type <Parent entity>.

 

Internally this relationship is via the internal GUID (system generated) of the parent record, but for display purposes shows the value of the "name" field of the parent record.

 

E.g in your example the minimum you would create of a one-to-many would be 

Project

  • Name

Employee

  • Name
  • Lookup (Project)

(and any other fields you want on the respective entities)

 

Alan2022
Frequent Visitor

Hi @Fubar 

 

Thanks for the clarification.
I thought i need to created an reference id in the employee table.
Keep up the good job. 👍

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (1,592)