vasantq

Obviously, I don't know the names of your objects or fields but hopefully from this will be enough to show you a method of doing what you want. BTW, I have assumed that your "Planning Week" object has a Date field which contains the starting date of the planning week (just because it makes it a lot easier to write the below). If you don't have such a field then you could either add one to your data structure or if the name of the record contains the date you can modify the code with some text-date conversions to make it work.

My example code has no error checking. For this kind of trigger you should probably do things like ensure the "next" Planning Week actually exists before reparenting the Innovation_Planning record, etc, etc.

Finally, a Master-Detail field needs to specifically be set up to allow reparenting—there's a checkbox in the edit field page. I am pretty sure, although not 100%, that this restriction cannot be overridden by apex code so make sure the checkbox is selected.

trigger ReparentToNextPlanningWeek on Innovation_Planning__c (before update) {

    private date nextPWDate;
    private Planning_Week__c currPW;
    private Planning_Week__c nextPW;

    for (Innovation_Planning__c IP : Trigger.new) {
        if(IP.Carryover__c == TRUE) {
            IP.Status__c = NULL;
            IP.Percent_Complete__c = NULL;
            IP.Carryover_Count__c = IP.Carryover_Count__c+1;
            IP.Carryover__c = FALSE;
            
            // Find next Planning_Week and reparent
            currPW = [SELECT ID, StartDate__c FROM Planning_Week__c WHERE  ID = :IP.Planning_WeekID LIMIT 1];
            nextPWDate = currPW.StartDate__c.addDays(7);
            nextPW = [SELECT ID FROM Planning_Week__c WHERE  StartDate__c = :nextPWDate LIMIT 1];
            IP.Planning_WeekID = nextPW.ID;
        }
    }
}

Good luck.

MellowRen