New week, NEW JOB

Hi!
I've been travelling for the time eing. Penang-johor-penang-shah alam-penang-vietnam...fuhhhh what a tough month. So, back to the office work keep on increasing just like an exp graph. :( sigh
 now, i need to solve the linkage between FMEA-Control whichj i thought had long resolve. Hahaha..being management is such a GREAT thing when they can say a DONE work is still NOT DONE and NOT SATISFYING. :( sigh

Ok, back to what i want to complete this week :
first i need to change the FMEA + Control Plan + SPC to become a two way data entry.This will be done by changing the dropdown to a combobox, and adding this codes :

public void school_Changed(object sender, XmlEventArgs e)
{
  using (SPSite FormSite = new SPSite(ServerInfo.SharePointSiteUrl.ToString()))
  {
    using (SPWeb FormWeb = FormSite.OpenWeb())
    {
      //Get the list and query for the item - "Schools" is the name of the list I am retrieving
      SPList LookupList = FormWeb.Lists["Schools"];
      SPQuery MyQuery = new SPQuery();
      //"Title" is the field where I keep the school name
      ///my:myFields/my:school is the xpath to the school field
      MyQuery.Query = "<Where><Eq><FieldRef Name='Title' /><Value Type='Text'>" + GetDomValue("/my:myFields/my:school") + "</Value></Eq></Where>";
      SPListItemCollection ReturnedItems = LookupList.GetItems(MyQuery);
      //Add the item to the lookup list if no items were returned in the query
      if (ReturnedItems.Count == 0)
      {
        SPListItem NewItem = LookupList.Items.Add();
        ///my:myFields/my:school is the xpath to the school field
        NewItem["Title"] = GetDomValue("/my:myFields/my:school");

Then Walla!

Next i want to change the inner e form of FMEA to a more user friendly thing. That one need some brainstorming. Last time i just use email alert, this time...errrr~ dont know yet.

Last thing is to revamp the control plan form. hmmmm :( sigh.
Its STILL A BIG FAT BLURR~