It depends on the situation. If the couple were living on base/post and the spouse was found with the substance coming onto/off base or in a search of any type, then yes, it would definitely affect that person's career!
If a problem arises where the person using the substance is causing...