Yakusoku, you seem to have an unusually good understanding of how your alters need attachment not sex. How did that come about?
Sorry if the below ends up going very off topic.
***Very vague triggers, but because the question refers to sex, so does the answer***
Hrm...is it common to confuse the two? The majority of the transference I have experienced in my life has been with older males my dad's age and has been completely parental. I've only recently come to explicitly understand that as the activity of an alter, but years ago when I "put away" those sort of relationships, I did call it "quarantining" those parts or aspects of me. I won't say there has never been erotic transference underlaying those attachment feelings, but that is also from a specific part and happened at a very young age (like under 10) due to some stuff that's probably too triggering to share here, but suffice to say, the way those attitudes played out were so unhealthy and age-inappropriate that it was plainly obvious those desires were linked to something that went very wrong that I was trying to feel in control of by directing them at someone who would actually be safe. And now that the kids are out again, that (unfortunately young) part of me still flares up in my relationship due to the fact that my husband's sleep disorder means I have had a lot of invasive experiences in my life and they were more frequent than completely consensual experiences. Has that part tried to target my therapist? A little bit, but since I've had this experience before and know this particular part really well from years of just experiencing her, that what she really wants is just safe connection. However, she anticipates no one will love her unless they want to invade, so she has learned to be comfortable with the idea of invasion. It makes me pretty sad.
Anyway, how do I know all of this? It's a really good question. It's hard for me to explain it. My therapist has said from the moment he started reading my journals that he thought I had studied psychology (the closest I have gotten is a couple of Early Childhood Education courses in which attachment did come up). He is so intrigued by my processing that he has read over 220 pages of 1.15 spaced writing in nine months and declines every time I offer to stop sending it to him. I told him our second week that I did not do need and dependency, because I start to try to replace my father and feel humiliated and disgusted by that part of me. I described it having happened in high school with a teacher (which I realized at the time and shut down on purpose). I was aware of doing it in middle school as well and already had an abusive part that restricted me from connecting (reaching out for attachment) in that way. When he offered texting and other support, due to self-destructive impulses that were an attempt to manage those attachment feelings, I warned him again that I could not moderate connections appropriately, that it would be "all on or all off," but he didn't believe me. So, when I got desperately attached and read up on the technical term of transference and realized how common it was, I basically came at him with a map of my transference relationship with him and told, "See! I told you so! Look what you made me do!"

I'm not even sure if I answered your question, because I've felt like I've known since I was very little that I was seeking a parental attachment, even if I didn't have the right words to label it with. I always saw the sexual stuff as a blip that was very specifically related to me being "broken." Maybe I am wrong there, though, if other people have kiddos who confuse the two.
Edit: Ugh, I feel like I am coming across as pretty arrogant here, but all I'm trying to say is that I'm pretty intuitive about my "inner world" as my therapist calls it. It's to the point that many articles I've read since I allowed myself to explore DID, attachment, etc. were more jargony versions of things I've already written in my journal. For example, I had labeled my most abusive/persecutorial part as a "caretaker," because I knew it had a protective function to fend off attachment. Just Saturday, I read an article on how persecutorial alters are transformed protectors who see the host or other alters as the current threat to the safety of the system. If you had changed the word persecutorial to abusive and alters to parts or states, then I had basically already floated that theory in my journal a few months earlier.