I'm confused by triggered actions and I'm hoping someone can help.
I have two tables for tracking asset's by serial numbers.
One is asset information (make, model, size, serial number, etc) the other is asset hours which tracks when a asset is used and has installed_hrs and removed_hrs to track the time.
Asset information has a field called "Status" (installed, spare, out for repair) I would like a trigger that when installed_hrs (asset_hours table) > 0 the "status" in asset information table changes to "Installed"
So basically changed a field in one table based on a field in another table.
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
mdav20
I'm confused by triggered actions and I'm hoping someone can help.
I have two tables for tracking asset's by serial numbers.
One is asset information (make, model, size, serial number, etc) the other is asset hours which tracks when a asset is used and has installed_hrs and removed_hrs to track the time.
Asset information has a field called "Status" (installed, spare, out for repair) I would like a trigger that when installed_hrs (asset_hours table) > 0 the "status" in asset information table changes to "Installed"
So basically changed a field in one table based on a field in another table.
Thanks
Link to comment
Share on other sites
1 answer 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.