public void loadSuppliers()
    {
        String na = "Not Available";
        
        this.cmbSupp1.removeAllItems();
        this.cmbSupp2.removeAllItems();
        this.cmbSupp3.removeAllItems();
        this.cmbSupp4.removeAllItems();
        this.cmbSupp5.removeAllItems();
        this.cmbSupp6.removeAllItems();
        this.cmbSupp7.removeAllItems();
        this.cmbSupp8.removeAllItems();
        this.cmbSupp9.removeAllItems();
        this.cmbSupp10.removeAllItems();
        this.cmbSupp11.removeAllItems();
        this.cmbSupp12.removeAllItems();
        this.cmbSupp13.removeAllItems();
        this.cmbSupp14.removeAllItems();
        this.cmbSupp15.removeAllItems();
        this.cmbSupp16.removeAllItems();
        this.cmbSupp17.removeAllItems();
        this.cmbSupp18.removeAllItems();
        this.cmbSupp19.removeAllItems();
        this.cmbSupp20.removeAllItems();
        this.cmbSuppGlobal.removeAllItems();
        this.cmbSuppGlobal1.removeAllItems();
        
                this.cmbSupp1.addItem(na);
                this.cmbSupp2.addItem(na);
                this.cmbSupp3.addItem(na);
                this.cmbSupp4.addItem(na);
                this.cmbSupp5.addItem(na);
                this.cmbSupp6.addItem(na);
                this.cmbSupp7.addItem(na);
                this.cmbSupp8.addItem(na);
                this.cmbSupp9.addItem(na);
                this.cmbSupp10.addItem(na);
                this.cmbSupp11.addItem(na);
                this.cmbSupp12.addItem(na);
                this.cmbSupp13.addItem(na);
                this.cmbSupp14.addItem(na);
                this.cmbSupp15.addItem(na);
                this.cmbSupp16.addItem(na);
                this.cmbSupp17.addItem(na);
                this.cmbSupp18.addItem(na);
                this.cmbSupp19.addItem(na);
                this.cmbSupp20.addItem(na);
                this.cmbSuppGlobal.addItem(na);
                this.cmbSuppGlobal1.addItem(na);
        
        
        String proList = "select sName as 'field' from supplier where sName != 'deleted'";
   
        
      
        
        ResultSet countList = db1.executeSQLQuery(proList);
        
        try
        {
            while(countList.next())
            {
                //n1 += Integer.parseInt(count1.getString("field"));
                this.cmbSupp1.addItem(countList.getString("field"));
                this.cmbSupp2.addItem(countList.getString("field"));
                this.cmbSupp3.addItem(countList.getString("field"));
                this.cmbSupp4.addItem(countList.getString("field"));
                this.cmbSupp5.addItem(countList.getString("field"));
                this.cmbSupp6.addItem(countList.getString("field"));
                this.cmbSupp7.addItem(countList.getString("field"));
                this.cmbSupp8.addItem(countList.getString("field"));
                this.cmbSupp9.addItem(countList.getString("field"));
                this.cmbSupp10.addItem(countList.getString("field"));
                this.cmbSupp11.addItem(countList.getString("field"));
                this.cmbSupp12.addItem(countList.getString("field"));
                this.cmbSupp13.addItem(countList.getString("field"));
                this.cmbSupp14.addItem(countList.getString("field"));
                this.cmbSupp15.addItem(countList.getString("field"));
                this.cmbSupp16.addItem(countList.getString("field"));
                this.cmbSupp17.addItem(countList.getString("field"));
                this.cmbSupp18.addItem(countList.getString("field"));
                this.cmbSupp19.addItem(countList.getString("field"));
                this.cmbSupp20.addItem(countList.getString("field"));
                this.cmbSuppGlobal.addItem(countList.getString("field"));
                this.cmbSuppGlobal1.addItem(countList.getString("field"));
            }
        }
        catch(Exception e)
        {
            JOptionPane.showMessageDialog(null, e.getMessage(),"METROPOLITAN ENGINEERING (PVT) LTD", 1);
        }
    }