Welcome to the SR family!
I am glad you are here but sorry for the reasons that sent you here. You have found a wonderful resource of support and information. Please make yourself at home by reading and posting as much as needed.
I dont know how the military works or how they handle substance abuse, someone with more experience may be along to help with that information.
Have you looked into local support for yourself? Therapy or alanon or naranon may help you as you try to make sense of the chaos addiction brings to our lives.
Keep reaching out for support, you are worth the effort!