He was upfront with you. Your job is to accept that what you want is not likely to happen. Until you accept that fact, you are going to be miserable.

Good luck.