public void loadAllClientReps(){//COMPLETE
        try {        
            ResultSet dbAllClientReps = null;
            Statement statement;
            statement = connection.createStatement();
            dbAllClientReps = statement.executeQuery( "SELECT ClientRep.clientRepID, ClientRep.organisationID, ClientRep.contactNo, ClientRep.email FROM ClientRep;");                     

            while(dbAllClientReps.next())
            {
                Client tempClient = null;
                User tempUser = null;
                for (int i=0; i<allClients.size();i++){
                    if(allClients.get(i).getClientID()==(dbAllClientReps.getInt("organisationID")))
                    {
                        tempClient = (allClients.get(i));
                    }
                }
                for (int i=0; i<allUsers.size();i++){
                    if(allUsers.get(i).getUserID()==(dbAllClientReps.getInt("clientRepID")))
                    {
                        tempUser = (allUsers.get(i));
                    }
                }
                ClientRep tempClientRep = new ClientRep(tempUser, tempClient, dbAllClientReps.getString("contactNo"), dbAllClientReps.getString("email"));
                allClientReps.addClientRep(tempClientRep);
            }
        } catch (SQLException ex) {
            Logger.getLogger(testFrame3Tim.class.getName()).log(Level.SEVERE, null, ex);
        }
    }