I have some tables that look like so:
When in the detail view of Project, I need to be able to add a new switch record and associate it with the project. I have added an action that navigates to a view based on a slice of Switch to allow a new record to be added.
Here is my problem: Once I press SAVE on the Add Switch view, I need a record created in the ProjectSwitches table to marry this record of switch to the project it is being added to. So I need to add a record to that table with switchID from the new switch and the SO from the Project record that launched the action.
I would appreciate if anyone could give me some guidance on how to make this association.