Having HE shouldn't effect your ability to find or maitain a long and wonderful relationship. You wouldn't want to be in a relationship with someone who isn't loving, kind and supportive anyway, you having HE won't matter to the right person. My husband of 21 years has learned about HE and can recognize the signs and symptoms sometimes before I do.
Educate yourself and your partner.