We need to come to terms with our own sexual needs and desires for excitement and stimulation. Dreaming of an affair allows us to release such feelings. We may feel the need to do something naughty or something that means we have to take emotional risks.