Could someone help, in my app, so far i can search for a record and display in a form - (which is working, thanks to help here.),
but i wish to add information, as in work carried out to a piece of equipment, in the form
This work carried out will happen several times on the same piece of equipment.
Would also like a time stamp and record person adding data.
Solved! Go to Solution.
Please see my blog posts on how to design your tables https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Relational-Database-Principles-and-Pow...
and the follow up post on how to implement them in PowerApps https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Relational-Database-Design-fundamental...
Thanks @Drrickryp very good reading,
You state "All tables are connected by Primary and Foreign keys." how do I know I have done this?
I have selected "many to one" for Works to Equipment in the properties.
I have "TAG" as the 1st column in both tables. My lookup in Works table will only let me select what is in the TAG column in the equipment table.
The overall aim is to add works carried out to pieces of equipment and to see a history of works when I select the equipment.
Dataverse creates the relationship automatically. You can use dot notation to implement it. Check out Dataverse's Northwind sample database to see how it's done.
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!