public static Map<String, String> returnShipAdviceHeader(String identifier) {
        // Select the customer ID from the table and add to the map.
        Map<String, String> headerValues = new HashMap<String, String>();
        if (conn == null) {
            getConnection();
        }
        try {
            String sql = "SELECT CustomerID FROM tblSalesHeader WHERE **column** = " + identifier;
            String asnSql = "SELECT ShipFirstName, ShipLastName, ShipAdd1, ShipCity, ShipState, ShipPostalCode, ShipCountry, ShipVia, ShipRequestDate" +
                    " FROM tblASNSalesHeader WHERE CustomerID = " + identifier;
            String customerAsnSql = "SELECT CustomerOrderDate, CustomerOrderType, ShipRequestWarehouse, OrderCompleted FROM tblASNSalesHeader " +
                    "WHERE CustomerID = " + identifier;
            Statement customerStatement = conn.createStatement();
            Statement shipStatement = conn.createStatement();
            Statement customerShipStatement = conn.createStatement();

            ResultSet customerId = customerStatement.executeQuery(sql);
            ResultSet shipInfo = shipStatement.executeQuery(asnSql);
            ResultSet customerShipDetails = customerShipStatement.executeQuery(customerAsnSql);

            if (customerId != null) {
                while (customerId.next()) {
                    headerValues.put("customer-id", customerId.getString(1));
                }
            }
            if (shipInfo != null) {
                while (shipInfo.next()) {
                    headerValues.put("ship-first-name", shipInfo.getString(1));
                    headerValues.put("ship-last-name", shipInfo.getString(2));
                    headerValues.put("ship-addr1", shipInfo.getString(3));
                    headerValues.put("ship-city", shipInfo.getString(4));
                    headerValues.put("ship-state", shipInfo.getString(5));
                    headerValues.put("ship-postal-code", shipInfo.getString(6));
                    headerValues.put("ship-country", shipInfo.getString(7));
                    headerValues.put("ship-via", shipInfo.getString(8));
                    headerValues.put("ship-request-date", shipInfo.getString(9));
                }
            }
            if (customerShipDetails != null) {
                while (customerShipDetails.next()) {
                    headerValues.put("customer-order-date", customerShipDetails.getString(1));
                    headerValues.put("customer-order-type", customerShipDetails.getString(2));
                    headerValues.put("ship-request-warehouse", customerShipDetails.getString(3));
                    headerValues.put("order-completed", customerShipDetails.getString(4));
                }
            }
        } catch (SQLException sqle) {
            sqle.printStackTrace();
        }
        return headerValues;
    }