Wanting more from someone: reflection on friendships and romantic relationships

We've been talking about boundaries and inner yes and no in a previous podcast and I've been wondering about that in relation to friendship and connection with people who we want a romantic relationship with but when that is seemingly not possible. The tension between wanting the person in our life still but not being able to have them in our life in the way that we would really desire. What do we do with that? What does an exploration of reality and 'no other' have to say?