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

[Alan2022]

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

[Fubar · Accepted solution]

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]

Hi @Fubar 

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