Jump to content
  • 0

Triggered action for loop to normalize data


NickO

Question

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
Link to post
Share on other sites

3 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...