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.
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.
Question
roattw
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!
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.