Hello all, see who can help in my hour of need .
(Version 5.0.0f CE, on MySQL and debian server
I am currently trying to divert sugar fields to those in a separate MySQL view. I would like to link the 'website' field in the 'account' table to the 'website' field in my 'accountview' table which is a view of a different database on the same server. I entered the following code into the accounts vardefs file. I understand that a mass import of data would suffice, however I am looking to link many more fields in this way. The fields in the view are website and account_id, if this helps.

'website' =>
array (
'name' => 'website',
'rname' => 'website',
'id_name' => 'account_id',
'massupdate' => false,
'vname' => 'LBL_WEBSITE',
'type' => 'relate',
'link'=>'accountview',
'table' => 'accountview',
'isnull' => 'false',
'dbType' => 'varchar',
'source'=>'non-db',
'len' => 36,
),
I’m sure the combined minds of Sugar can solve this tiny little issue, so please help
Regards
John