public static ArrayList Ticket_ComboBox(Integer ID) {
            ArrayList number = new ArrayList();
            Database db = dbconnect();
            String query;
            Object noEmployee = "";
            boolean _int = false;
	try {
                switch (ID) {
                case 1:  query = ("SELECT CID FROM customer WHERE bDeleted = 0 ORDER BY CID");
                         _int = true;
                         break;
                case 2:  query = ("SELECT username FROM employee WHERE bDeleted = 0 ORDER BY EID");
                         number.add(noEmployee);
                         break;
                case 3:  query = ("SELECT description FROM problem_category WHERE bDeleted = 0 ORDER BY CategoryID");
                         break;
                default: query = ("SELECT description FROM ticket_status WHERE bDeleted = 0 ORDER BY StatusID");
                         break;
                }
                db.prepare(query);
		ResultSet rs = db.executeQuery();   
                while(rs.next()) {
                    if (_int) {
                        number.add(rs.getInt(1));
                    } else {
                        number.add(rs.getString(1));
                    }
		}
	        db.close();      

        } catch (SQLException e) {
            Error_Frame.Error(e.toString());
        } 
        return number;
    }