Some of the relationships were so serious that the officers themselves were prosecuted or sacked but many others were simply moved to another post, the Daily Mail reported.