You’re offline. This is a read only version of the page.
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
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-PowerApps-Step-3-Keys-and/ba-p/188640 and how to implement them here. https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/Relational-Database-Design-fundamentals-Implementing-a-One-to/ba-p/200521
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.
Share
Report
All responses (
Answers (
842
