How to display related field?

[asbaeza]

Hi.

I am using some custom fields related to other tables. For example, one of them is related to accounts id (a customized id indeed) . I can select or type this field, but do not know how to display the account name, as a way to validate I am using the right desired value (so reducing wrong typing possibilities).

Does anyone know hot to achieve this?

[lion]

you can either retrieve the name in php code (probably in a fill_in_additional* function) and display the result or you can do something like this (this works in the listview and should also work in the detailview):

   'account_id' => 
  array (
    'required' => false,
    'name' => 'account_id',
    'vname' => '',
    'type' => 'id',
    'massupdate' => 0,
    'comments' => '',
    'help' => '',
    'duplicate_merge' => 'disabled',
    'duplicate_merge_dom_value' => 0,
    'audited' => 0,
    'reportable' => 0,
    'len' => 36,
  ),
  'account' => 
  array (
    'required' => true,
    'source' => 'non-db',
    'name' => 'account',
    'vname' => 'LBL_ACCOUNT',
    'type' => 'relate',
    'massupdate' => 1,
    'comments' => '',
    'help' => '',
    'duplicate_merge' => 'disabled',
    'duplicate_merge_dom_value' => '0',
    'audited' => 0,
    'reportable' => 0,
    'len' => '255',
    'id_name' => 'account_id',
    'ext2' => 'Accounts',
    'module' => 'Accounts',
    'quicksearch' => 'enabled',
    'studio' => 'visible',
    'rname' => 'name',
    'link' => 'account_link',
  ),
    'account_link' => 
    array (
      'name' => 'account_link',
      'type' => 'link',
      'relationship' => 'account_search',
      'vname' => 'LBL_ACCOUNT',
      'link_type' => 'one',
      'module' => 'Accounts',
      'bean_name' => 'Account',
      'source' => 'non-db',
    ), 
  

along with the relationship:

     'relationships'=>array (
 'account_search' => 
    array (
      'lhs_module' => 'Accounts',
      'lhs_table' => 'accounts',
      'lhs_key' => 'id',
      'rhs_module' => 'oqc_ExternalContract',
      'rhs_table' => 'oqc_externalcontract',
      'rhs_key' => 'account_id',
      'relationship_type' => 'one-to-many',
    ),  
), 
  

[bhawin13]

lion,

Thanks for good useful post.
It has helped me to solve my problem.

I would like to add more thing that at some place, where field of type= relate, metadata information of link is (for ex: 'link' => 'account_link') is missed but it is really important to show field value in list view, specially if field is not like account_name, project name. If you want to show project start date of project in list view of any other related module of project then 'link' attribute is important.