.For any Engineer if any course status for a Program is having atleast one expired status Program status for that program will be expired .For any Engineer If all course status for a Program is completed then only program status for that program is completed .For any Engineer If Course status for a Program is having combination of only Enrolled and Completed then program status for that program is Enrolled
However I need Program status independent of Resource.
Do you mean the program status should be in another table? If so, you can create the Keyfield in your original table, and do the resident of that table with Keyfield, and Program status field. If not, can you explain further?