Joing Tables in Power apps and entering data from multiple tables in one data card

[craigmon]

Hi Guys, i'm pretty new to powerapps so before i start trying to build something, i want to see if the below scenario is possible. I have 3 tables:

1 customer table -  containing customer name, customer id

2 monthly figures - containing customer name, customer id, month_year, result

3 comments table  - containing customer name, customer id, month_year, comment

The relationship to all is the customer id.  I need to somehow write the data back to each table so i can eventually query the database and  pull out all of the relating data for each customer. 

I would like to build an app so the user can select the customer name, select the month, enter the result and enter a comment.  The user will only ever enter one result for each month, but could enter multiple comments for each month.  Is this possible in power apps and can this all be done in the same edit form and do any of you have any examples of this? 

Many thanks

[Drrickryp]

@craigmon 

Please check out my blog post on how to design the one to many relationships in PowerApps here: https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Relational-Database-Principles-and-Pow...  and how to implement them here.  https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/Relational-Database-Design-fundamentals... 

It looks like you have a one to many relationship between customers and months/years and a second one to many relationship between months/years and comments.