SupplierRelate.php - definition of the 2 fields required for the relationship without middle table

SupplierRelate.php

<?php

/*
 * Name relate field
 * * link point at the link field defined below
 * * make sure the field name matches the pattern <bean_name>_name
 */
$dictionary['Demo_SupplierContactDetails']['fields']['demo_suppliers_name'] = array(
    'required'  => true,
    'source'    => 'non-db',
    'name'      => 'demo_suppliers_name',
    'vname'     => 'LBL_SUPPLIER_NAME',
    'type'      => 'relate',
    'rname'     => 'name',
    'id_name'   => 'demo_suppliers_id',
    'join_name' => 'demo_suppliers',
    'link'      => 'demo_suppliers',
    'table'     => 'demo_suppliers',
    'isnull'    => 'true',
    'module'    => 'Demo_Suppliers',
);

/*
 * Linking id field
 * * make sure the field name matches the pattern <bean_name>_id
 */
$dictionary['Demo_SupplierContactDetails']['fields']['demo_suppliers_id'] = array(
    'name'              => 'demo_suppliers_id',
    'rname'             => 'id',
    'vname'             => 'LBL_SUPPLIER_ID',
    'type'              => 'id',
    'table'             => 'demo_suppliers',
    'isnull'            => 'true',
    'module'            => 'demo_suppliers',
    'dbType'            => 'id',
    'reportable'        => false,
    'massupdate'        => false,
    'duplicate_merge'   => 'disabled',
);