using you suggestion for sub queries, I came up with tis revised code, only problem is I get a error like

Error 2 'BusinessObjects.esBillOfMaterialsQuery' does not contain a definition for 'OnLoadEvent' C:\Documents and Settings\rich\My Documents\Visual Studio 2005\Projects\TangoUI\TangoUI\Generated\BillOfMaterials.cs 48 19 TangoUI

I been quite a while since I upgraded, been working with 2007 for so long, would a subquery like this REQUIRE 2008 ES and new 2008 templates in MyGeneration??  

Code:

private void LoadVendors()
        {
            
            object[] list = new object[m_parts.Count];
            int i = 0;

            foreach (BusinessObjects.Part  part in m_parts)
            {
                list = (int)part.PartID;
                i++;
            }

            BusinessObjects.PartVendorQuery  sub = new BusinessObjects.PartVendorQuery();
            sub.Select(sub.VendorID);
            sub.Where(sub.PartID.In(list));
            
            BusinessObjects.VendorQuery main = new BusinessObjects.VendorQuery();
            main.Select(main.VendorID,
                        main.Name,
                        main.AccountNumber);
            main.Where(main.VendorID.NotIn(sub));

            m_vendors = new BusinessObjects.VendorCollection();
            m_vendors.Load(main);

          
        }