AllProductData.Relations.Add("DepartmentCategory", AllProductData.Tables["Departments"].Columns["DepartmentId"], AllProductData.Tables["Categories"].Columns["DepartmentId"], true);
                AllProductData.Relations.Add("FamilyDepartment", AllProductData.Tables["Families"].Columns["FamilyId"], AllProductData.Tables["Departments"].Columns["FamilyId"], true);
                AllProductData.Relations.Add("CatagorySubCatagory", AllProductData.Tables["Categories"].Columns["CategoryId"], AllProductData.Tables["SubCategories"].Columns["CategoryId"]);
                AllProductData.Relations.Add("SubCatagoryProduct", AllProductData.Tables["SubCategories"].Columns["SubCategoryId"], AllProductData.Tables["Products"].Columns["SubCategoryId"]);