Attached is my database. In the update query I am attempting to update the recommended action field in tbldelinquent.
Here is the outcome I want from the scenario:
Everything in the query is working except when it goes to update record 10 in the CMDelinquent table. The recommended action should be Delinquent to HR.
Here is what I am trying to accomplish-
1st time person exceeds their required date - Delinquent to HR (for each course they must go to HR first)
Then everytime after this the recommended action is progressive
so next time no would be Notice to File and the time after MEMO 1 no matter which course
But the first time they are delinquent for ANYcourse the recommended action must be Delinquent to HR