Node reference based on url

CCK field has a widget part for editing/creating the node and formatters part for output. CCK field widget normally is some form element. Nodeincck's widget just display the content of a node. That's why in the node edit form, static text from another node is shown.

For what you need, use this module with token. In the nodeincck field config where you enter a node id, you can put a token instead. Let's say this token is [writing-training-scenario].

The second part is to create this "[writing-training-scenario]" token to do the "finding the node to display base on the URL". This involve writing some code/module. Something like this:

/**
 * declare the existence of this token
 */
function MYMOUDULE_token_list($type = 'all') {
  if ($type == 'node' || $type == 'all') {
    $tokens['node']['writing-training-scenario'] = t('Writing training scenario based on some super duper algorithm');
    return $tokens;
  }
}

/**
 * Compute the token value
 */
function MYMODULE_token_values($type, $args = NULL) {
  if ($type == 'node') {
    $tokens['writing-training-scenario'] = _MYMODULE_my_super_duper_algorithm($args);
  }
}

function _MYMODULE_my_super_duper_algorithm($args) {
  // do you thing here
  $whatever = _GET['scenrio'];
  //   .....
  return $nid;
}

Let me know if you need help or something I need to fix in this module.