private void initSupervisorField(String job){
        supervisorField.removeAllItems();
        supervisorField.addItem("");
        try{
        String sql = "select empNo, fName, lName from Employee where jobTitle = '" + job + "' and empStatus != 'Terminated'";
        conn = DBConnect.connect();
        pst = conn.prepareStatement(sql);
        rs= pst.executeQuery();
            while(rs.next()){
                supervisorField.addItem(rs.getString("fName") + " " + rs.getString("lName"));
                emplNo.add(rs.getString("empNO"));
            }
        }
        catch(Exception e){
            JOptionPane.showMessageDialog(null, e);
        }
        finally{
            if(pst != null){
                try{
                    pst.close();
                }
                catch(SQLException ex){
                    JOptionPane.showMessageDialog(null, ex);
                }
            }
            if(rs != null){
                try{
                    rs.close();
                }
                catch(SQLException ex){
                    JOptionPane.showMessageDialog(null, ex);
                }
            }
            if(conn != null){
                try{
                    conn.close();
                }
                catch(SQLException ex){
                    JOptionPane.showMessageDialog(null, ex);
                }
            }
        }
    }