Princess Diana cheated on Prince Charles with a Captain in the British Army
Despite the fact that it was open knowledge that Prince Charles was cheating on Diana with Camilla Parker (among others), it was apparently a bigger scandal that she was cheating on him.
Nevertheless, it lasted 5 years, and was terminated by Diana. A few years later, the couple divorced.