This happens all the time. There are guys that live next to military bases specifically because they fuck around with deployed soldier's wives. They are called "Jody" in the Army. There are even cadences sung about how your wife is going to cheat on you, you have no home to go back to, so you may as well enjoy your deployment.