Triggered action for loop to normalize data

[NickO]

I have two tables that are linked with a relationship table. Basically a Problem table (Fields: ID, Name, Description, etc.) and Vertical table (Fields: ID, Name, Description, etc.) linked by a ProblemVertical relationship table (Fields: ProblemID, VerticalID). The ProblemVertical is a many to many table. The Vertical list is relatively static. The Problem list is very dynamic. Any time I add a new Problem, I want to create a relationship to each of the current Verticals. So, if I have the Vertical table as below and add Problem 1 to the Problem table, I want to automatically create the records in ProblemVertical as shown below. I could hard code in the Vertical IDs to a triggered action, but that would be a pain on the occasion that a vertical changes or is added/removed. I would prefer to be able to loop through the Vertical table somehow when I add a record to the Problem table.

Problem Table			Vertical Table			ProblemVertical Table
ID	Name		ID	Name		ProblemID	VerticalID
Prob1	Problem 1		Vert1	Vertical 1		Prob1	Vert1
			Vert2	Vertical 2		Prob1	Vert2

[carlJS]

This Triggered Action should relate the #inserted Problem to all of your Verticals in the ProblemVertical table.

 

 

Note: I used autonumber for the IDs.

 

Export the attached file for live working example

 

Tables_2019-Nov-22_0657.zip
 

[carlJS]

Bonus Round !!!

If you wish to fill the missing ProblemVertical records, [perhaps if new Verticals were added and you wish to relate this with pre-existing Problems] you may use the Task below. Then run it on demand.

 

 

[src="carl.js"]

[NickO]

@carlJS my apologies for not getting back to you on this. It must have gotten lost in the shuffle somehow. Thank you very much! This is what I was trying to put together and was failing miserably.