i got 2 tables : 1 for member personnel detail (MemberID,MemberName,College,Department,Degree,Gen eral_specifation,
Specialization,Date_Of_Hiring,MasterDate,PHD_Date)
and the other table for mission for each member
(MemberID,MissionType,Date_of_approve,Destination,TravelDate,ReturnDate,
DepartmenapproveDate,FacultyApproveDate,UnivApproveDate,ExtendDate1,ExtendDate2,ExtendDate3)
i have mission types
type1 ,type2 , type3 , type 4
type1 duration 4 years and can't be extended
type 2 can be extended for 2 years , each time for 3 monthes only ,for ex : from 1/3/2017 to 1/6/2017 , can be extended to 1/9 , 1/12 , 1/3/2018
and so on