Associating records between multiple views

[Erik_Meyer]

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.