Jump to content
  • 0

This Trggered action to Update a record used to work - but now keeps giving me a new entry


roattw

Question

When updates made to one table, those changes should update in another table.  Had this working at one point, now, instead of updating the record it creates a new entry with those changes.

Main Directory Table. (with triggers)
When person flagged as Alumni in Directory table, that record gets copied to Alumni table (Alumni). Image 1.  Works fine.
Since they can be in Directory and Alumni table, any changes to Directory fields (like address changes, etc) need to also get updated in the Alumni table as well for that person. (Image 2).  Except getting duplicates now.

Many thanks for thoughts!

caspio_insert.png.3e6646fd401b9d1dafe6d74e388f6fb9.png

caspio_update.png.8fe3ff67a26b4a18d0e8d27b42a54e60.png

Link to comment
Share on other sites

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