So I’m working on an app to help organize and quickly fill out forms and update information on the go from mobile device. So far, I love this app! However, I’m stuck doing the following.
I have a table for:
Equipment (laptops, speakers etc.) Saves data related to the equipment and who owns it currently USER_ID.
Assignment Forms (A form to fill out when equipment changes ownership) Has unique FORM_ID, USER_ID (max. 1) and date, and a virtual table that contains all equipment that will be assigned on this form.
Assignment registries (Created by adding equipment to assignment form) Saves FORM_ID of the Assignment form it belongs to, the id of the equipment it will modify and the reason of the ownership change.
So what I need to do now is create an action(s) triggered by a button, that will update the USER_ID in equipment table using the USER_ID from the Assignment form, and do this for every registry with the same FORM_ID where I clicked the button.