Auto node redirct depending on a cck field's content
There is multiple way of doing this. Probably the best one is create a custom module and 

Using hook_menu_alter(), alter the page callback for node/%node. In your page callback, check the type of the node to invoke node_page_view on the node or redirect to the referenced node.

MODULE_menu_alter(&amp;$items) {
  $items['node/%node']['page callback'] = 'MODULE_node_page_view';
}

MODULE_node_page_view($node) {
  if ($node-&gt;type == MODULE_NODE_TYPE) {
    //if fixed_x is a node nid
    $reference = $node-&gt;field_x;
    drupal_goto('node/'. $referenced_node-&gt;nid);
    //if fixed_x is a path
    drupal_goto($node-&gt;field_x);
    //etc
  }
  else {
    return node_page_view($node);
  }
}