My dream job offer just came through, but it's in a city where my long-term partner has absolutely no career prospects and a strong family tie, and they've made it clear they won't move. Do I take the job, knowing it likely means the end of our relationship, or turn it down and stay, sacrificing a major professional opportunity?