adding a new vardef to the correct module whick allows creating a new relationship.

$dictionary["CampaignLog"]["fields"]['created_url'] = array (
    'name' => 'created_url',
    'vname' => 'LBL_CREATED_URL',
    'type' => 'link',
    'relationship' => 'campaignlog_url',
    'source'=> 'non-db',
);


$dictionary["CampaignLog"]['relationships']['campaignlog_url'] = array( 'lhs_module'=> 'CampaignLog',
    'lhs_table'=> 'sa',
    'lhs_key' => 'related_id',
    'rhs_module'=> 'sa_clicked_urls',
    'rhs_table'=> 'sa_clicked_urls',
    'rhs_key' => 'id',
    'relationship_type'=>'one-to-many');