Even in circumstances where independently neither the wind or the tide appears problematic to your dive these two natural forces can combine to produce a serious threat to diver safety.
Wind pushing against the tidal flow often produces dangerously unpredictable conditions for a vessel and for divers on or near the surface. Wind running in the same direction as the tide can make it extremely difficult to return a vessel.
Experience is the key to anticipating the effect and specific set of weather and tide parameters with have on a dive location.