Thanks! 

I'm expect to do a bulk load and in order to get the info ready for analysis, I need to link each record to the appropriate objects/records upon upload.

I would like to do the following:

1) do a test -- then based on the result, set a field value.

 

In this case, if sa[0].StudentID_SIS__c = XXX, then set a field sa[0].Record_Type__c to YYYY).  In other triggers I have several tests... but basically its the same type of test and do

 

2)  I also want to set the values of a field based on a field in a related object

 

In this case, I basically want to set sa[0].Related_District_Account__c and sa[0].Related_School_Account__c. 

 

• Set the field sa[0].District_Account__c to the Account.Id where

sa[0].Account_D_code__c = Account.Account_D_Code AND

Account.Account_S_code = '0000000'. 

• Set the field sa[0].School_Account__c to the Account.id where

sa[0].Account_S_code__c = Account.Account_S_code__c

Any help would be great!!

Here's the entire trigger if it helps.

trigger UpdateStudentAttendance_Before on Student_Attendance__c (before insert, before update) { //--------------------------------------------------------------- // Establish variables //---------------------------------------------------------------- String saID = null, saDistrict = null, saSchool = null, saCDS = null; String RelatedSchoolId = null, RelatedDistrictId = null, RelatedStudentId = null; String temp_studentid = null, temp_recordtype = null; Integer saCDSlength = 0; Student_Attendance__c[] sa = trigger.new; saID = sa[0].Id; saDistrict = sa[0].Account_D_Code__c; saSchool = sa[0].Account_S_Code__c; saCDS = sa[0].Account_CDE_Code__c; if (saCDS <> null) { saCDSlength = saCDS.length(); } //---------------------------------------------------------------- // Update Related School and District //---------------------------------------------------------------- // If CDS code exists then parse it for the District and School Accounts if (saCDSlength == 13) { saCDS = '0' + saCDS; saCDSlength = saCDS.length(); } if (saCDSlength == 14) { saDistrict = string.valueof(saCDS.substring (2, 7)); saSchool = string.valueof(saCDS.substring (7,14)); try { RelatedDistrictid = [select id, CDS_Code__c,Account_D_code__c from Account where (Account_D_code__c = :saDistrict and Account_S_code__c = '0000000')][0].id; RelatedSchoolid = [select id, CDS_Code__c, Account_S_code__c from Account where Account_S_code__c = :saSchool][0].id; } catch (system.Exception e1) { } } // If the District code exits then parse for the District Account else if (saDistrict <> null) { try { RelatedDistrictid = [select id, CDS_Code__c,Account_D_code__c from Account where (Account_D_code__c = :saDistrict and Account_S_code__c = '0000000')][0].id; } catch (system.Exception e2) { } } else { } //---------------------------------------------------------------- // Update Related Student & Record Type //---------------------------------------------------------------- temp_studentid = sa[0].StudentID_LMS__c; if (temp_studentid <> null) { temp_recordtype = 'online - coaching'; try { RelatedStudentId = [select id, Extreme_Student_ID__c from Student__c where Extreme_Student_ID__c = :temp_studentid].id; } catch (system.Exception e3){ } } temp_studentid = sa[0].StudentID_SIS__c; if (temp_studentid <> null) { temp_recordtype = 'onsite - coaching'; try { RelatedStudentId = [select id, Extreme_Student_ID__c from Student__c where Extreme_Student_ID__c = :temp_studentid].id; } catch (system.Exception e4){ } } //---------------------------------------------------------------- // Set fields for Updating //---------------------------------------------------------------- sa[0].Related_School_Account__c = RelatedSchoolid; sa[0].Related_District_Account__c = RelatedDistrictid; sa[0].Related_Student__c = RelatedStudentid; sa[0].Record_Type__c = temp_recordtype;