data display in subpanel

[allenl]

I created a custom module (quotation) and there was column called OpportID in table which stored the opportunityID.
I want to display the opportunity name in subpanel but fails. I can only get the opportID. Any suggestion
will be really appreciated.

-------quotation/subpanels/default.php-----------
'OpportID'=>array(
'name' => 'OpportID',
'vname' => 'LBL_OPPORTUNITY_ID',
'width' => '10%',
),


---------------------vardefs.php---------------
'OpportID'=>
array (
'name' => 'OpportID',
'rname' => 'name',
'id_name' => 'id',
'vname' => 'LBL_OPPORTUNITY_ID',
'type' => 'Opportunity',
'table' => 'opportunities',
'isnull' => 'false',
'dbType' => 'id',
'len' => '36',
'reportable'=>false,
'comment' => 'opportunity name'
),
'Opportunity' =>
array ( 'name' => 'Opportunity',
'vname' => 'LBL_OPPORTUNITY',
'type' => 'varchar',
'reportable'=>false,
'source'=>'non-db',
),
-----------------------------------------------end vardefs.php-------------

[pikpik]

I'm really not sure, but I think you should look at the implementation of the ContactOpportunityRelationship files. You will find them in your /modules/contacts folder.

Once you have found them, take a look at your contacts/vardefs.php file, and the in the /subpanel/ForOpportunities.php file to see how to use it.

I have already added a field 'comment' on my ContactOpportunity relationship (I use it to propose candidates for opportunities I have with some clients. So I want to know if they were introduced, not yet introduced, refused, accepted).

To display such a field, I found a subtable in the vardefs file of the contacts module which consists of all the field in the relationship they want to display. When this subtable is loaded, in the vardefs file again, they use the variables they just created and define them as standard variables.

What I did first is to add my field to the table opportunities_contacts, then I loaded it in this subtable, and declare it after this subtable in the contacts module. To display it then just add the variable name in the subpanel, or anywhere else you want it to be displayed.

Hope it will help!