AnsweredAssumed Answered

How can I add a relationship field to a subpanel?

Question asked by cfton cfton on Dec 5, 2014
Latest reply on Dec 7, 2014 by Muhammad Shaji Uddin
Hi,
I have a custom module its name in DRT_Access . It has a relation to Accounts module. This module has a sub-panel in Accounts module with following showing field :
DRT_parent_name,DRT_child_name
I need to add DRT_child_id into this subpanel.
I added this field name(DRT_child_id) into custom/modules/DRT_Access/Ext/vardefs.ext.php
by using :
$dictionary['DRT_Access']['fields']['DRT_child_id']['labelValue']='Child Account';

And in subpanel file I added :

'DRT_child_id' =>   array (
    'type' => 'char',
    'default' => true,
    'vname' => 'LBL_CHILD_ACCOUNT',
    'width' => '10%',
  ), 

But I got following error on Sugarcrm.log:
Unknown column 'DRT_child_id' in 'order clause'

May you help me how may I add this field in subpanel?

Thanks,
Rega.

Outcomes