URL link with field name for link text

I'm trying to essentially recreate the effect of having a relationship, and clicking the 'display as a link to the related record'. I'm trying to do that, without having the relationship. I have consi...