Hi there
I need to create a few forms for employee information (Colour coded questions below)
1. New employee
2. Change to existing employee info
3. Overwrite existing info as error on inputting details
The gallery is integrated in to power BI and will be writing back to the SQL Table in the DB
1. Add a New employee record (i've built a form for this) so this is OK
2. A form will submit a change and then it will insert a new row in to the table. I've already done this and a trigger has been created in SQL to insert it as a new row.
3. Create another form to overwrite data if they have made a mistake. This is where I am having an issue because in my mind it is the same as a change (see number 2). If someone changes a record or adds a new one and then they realise they have made a mistake, I want them to be able to go back and overwrite the error without it being seen as a change and a new row being inserted
How can I tell the app to overwrite the existing data without it thinking its a change.
Any help would be really appreciated
Many thanks
Karen
