I have a trigger in my database to update a project ID in two different tables if it changes in the Project table. My issue now is that I may have the same project ID for two different Employees so the only distinguishing factor is a combination of the Project ID and the Employee ID. How do I incorporate this so if one Employee changes the Project ID it doesn't change it for other employees with the same Project ID? HELP!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trigger help with multiple criteria
- Thread starter andis
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question