I'm not really sure exactly you are trying to ask here, but if you use drupal's l() function, it will return a link utilizing the aliases, eg:
$foo=l('Click here to goto bar','node/' . $nid);
will create a link using the url alias of the node in question (assuming of course that $nid
contains an actual node id).
You could use this in custom PHP code or in a PHP field in Views, but, I am also thinking you could use Views' field rewriting along with tokens to accomplish this as well if it is based upon a reference field inside another node as well that is included (and then hidden) in the View's fields.
ADDITION based upon commentary:
You could take a dull ax to this and do something along these lines in hook_init()...
function YOURMODULE_init() {
$mgo=menu_get_object();
if (!empty($mgo-> /* whatever field you are talking about in your content */ )) {
$nid= /* get the node id from that field */ ;
if ($nid && $nid!=$mgo->nid) {
drupal_goto('node/' . $nid);
}
}
// any other init stuff from your module goes here
}
...which would do the redirect upon page load so your users might see their browser address bar change quickly at the beginning but would end up at the right place.
Also realize you'd never be able to edit the node again without further logic added into the above :)