Jump to content
  • 0

Many forms to many tables using triggered actions/



HI All,

We have a group of clients that all want their own form to fill in their own data.  We want those forms to fill copy entries to two other tables.  One will be a master table (Cleaned) and the other we are hoping to have a table that shows every input including deletion from the second table.  

So each partner will have their personal data.  Then we will have a master table that combines all partners' data into one which is being cleaned for duplicate submissions by different partners.  The 3rd will be a master that will keep everyone data without being cleaned of duplicates.  

Can anybody walk me through if this is possible. 

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

Just to verify, how many tables are there exactly?

From what I understand, you have two tables. 

The first is the base table, where all the submissions are occurring, and the second one is a table where it will only take the unique records from the first table.

In that case, try this: 


Link to comment
Share on other sites

  • 0

By the way,  Should you wish to proceed with my suggestions above, just make sure you don't have an active 'Insert' Trigger in the 'Master' table. 

The trigger in the deletion from master table will cascade to the trigger on insert at the base table, which will then insert back to the 'master' table. It will exceed your nested level limit.

Link to comment
Share on other sites

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.

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.

  • Create New...