CaptnK
-
Posts
1 -
Joined
-
Last visited
CaptnK's Achievements
Newbie (1/14)
0
Reputation
-
CaptnK joined the community
-
Move records from one table to another based on a field's value
CaptnK posted a question in General Questions
I have two tables, Active_Users and Inactive Users. Each table has a user id, name, and status. I would like a trigger invoked on insert and updates to the Active Users table. The trigger moves records from Active Users to Inactive Users where the status = "inactive" in the Active Users table. Any help appreciated.