Help customize contacts module

[gtg182s]

I've create a table 'preferences' with columns id, data, comments

and table 'contacts_preferences' with column id, contact_id, preference_id.

What I want is whenever I visit
http://localhost/sugarcrmce/index.ph...&record=someID

It display all preference of some contact. (just for testing purpose)

How do I do it? Do I create a contacts_preferences relationship in contacts/vardef.php?

[ptemplin7]

could you get this to work with custom fileds instead of adding the table!

Sounds like what you would need si to think of the preferences as a module and add the link to the contacts. Use 5.1 or try to follow the Wiki for 5.0

Have fun, Why is this needed really?
Paris

[gtg182s]

Really I dont need preferences to be a module. Preferences are created/viewed in Contacts module, no where else. I can't create a custom field because the data schema is some what defined, given to me by someone.

I want to do it in vardef, just like getting account_name

'account_name' =>
array (
'name' => 'account_name',
'rname' => 'name',
'id_name' => 'account_id',
'vname' => 'LBL_ACCOUNT_NAME',
'join_name'=>'accounts',
'type' => 'relate',
'link' => 'accounts',
'table' => 'accounts',
'isnull' => 'true',
'module' => 'Accounts',
'dbType' => 'varchar',
'len' => '255',
'source' => 'non-db',
'unified_search' => true,
),

The difference is I dont want to get just one field like account_name, I want to get rest too.

Thanks,
Tri

could you get this to work with custom fileds instead of adding the table!

Sounds like what you would need si to think of the preferences as a module and add the link to the contacts. Use 5.1 or try to follow the Wiki for 5.0

Have fun, Why is this needed really?
Paris