He wants a relationship "in the future," but you'd like one now. Your wants aren't matching. At this point, I'm not sure what you can do that will produce the outcome you want. In the time that you would waste waiting for him, you could have met someone who's on the same page as you. It seems that the best thing you can do is move forward a little wiser... having learned from your mistake that booze and boys don't mix... and that you need to make sure a guy wants the same things you want before you get too hopeful about the potential. Remember to look before you leap.