Quote Originally Posted by OBP View Post
Yes, that is much better, although I am not sure about " As for the 3 there is no 3 thats in the code as a 0", but there is an "Operator 3" in the table.
The date issues from the fact that your database has the "Achieved Dates" for the first 5 Requirements as the 14th of September, ie in 2 days time
So if you set the Achievement date to nothing you want to delete the record it applies to in the table Employee level, what about the EmployeeFunctions table?
So how do the employees reach Operator 3, 4, 5, 6 & 7 levels and do they have to be in order or can they come straight in as say Operator 5?
I may be mixing up Functions & Operators here.
Ok, Yes there is an operator 3 BUT if you look at the requirements to be a Operator 3 it requires you to complete (4) functional Areas not it you only complete 3 which does nothing yet for any Operator 3,4,5 because they haven't produced enough functional areas.

Yes Operator 1,2,3,4,5 goes in order you cant jump, they start out at a Op1 and move up the chain.

Hope this helps....