I have four fields: Cost, Schedule, Performance, O verall Status.
Each field has four possible values: (1) Complete, (2) Major Issues, (3) Minor Issues, and (4) On Track.
Field value priority, from highest to lowest is: (2) Major Issues, (3) Minor Issues, (4) On Track, and (1) Complete.
I need a BASIC script that will compare the values in the Cost, Schedule, and Performance fields and place the highest prioity value contanied in the three fields in the Overall Status field.
For example, if the Cost field had a value of (2) Major Issues and the Schedule and Performance fields both had (4) On Track values, the the Overall Status field would reflect (2) Major Issues.
Any help would be much appreciated.