Jump to content
  • 0

Trigger to insert new record into three tables (one with multiple records) when new record is inserted into the Triggered table


KeithG
 Share

Question

Hi,

I'm New to Caspio and hope there is a simple answer to this question.

 

I have a table (Files) and I'm trying to create a trigger that, when a new record is created in Files, will add a new empty record with the same Id (FileNum) in three other tables.  Two of those tables need just one new record each and the third table needs four new records.  All records are blank except for the AutoNumber Id field called FileNum.

 

Thank you!

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

If the amount of times it must be copied to another table is fixed, then it is alright to just duplicate the insert block multiple times, however, if you want it to be dynamically based on the inserted record, you may want to consider using loop blocks. If you can provide me a screen shot of the tables from initial entry and their expected results, perhaps we can draft a sample trigger. 

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.

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...
 Share

×
×
  • Create New...