I have two tables.
Parent – Container Management
Child - Container Status.
User Group – Tied to Location table by user
I have a form on the Parent table where users can only enter records for their location
I have a webhook that pushes the initial status to the child table.
Where I’m having a hard time:
I currently have it setup to where my users edit in Grid mode but that’s not very user friendly on mobile devices..
I want to change to where they can edit from the form only
1. User selects location (Or it automatically knows based on their login/role based on another table.
2. It only lets them select from dropdown of containers that are still in Active status for their location3. Allows them to update the status and a few other new fields based on that status.