How to show multi fields of one relate module in a subpanel listview

[voka]

new custom modules: Product, Customer, QuoRecords

Product's fields: sn, name, vendor,cost.

Customer and QuoRecords are one to many.

QuoRecords has a relate type field called 'product_sn' that relates to a Product. And also 'quotation' and 'quo_date' field.

QuoRecords's list within Customer' subpanel.

Anyone can help on showing the following list of QuoRecords within a Customer' subpanel?

product_sn name vendor cost quotation quo_date
0001 mobile nokia 300 400 2010-06-09

[agcopley]

new custom modules: Product, Customer, QuoRecords

Product's fields: sn, name, vendor,cost.

Customer and QuoRecords are one to many.

QuoRecords has a relate type field called 'product_sn' that relates to a Product. And also 'quotation' and 'quo_date' field.

QuoRecords's list within Customer' subpanel.

Anyone can help on showing the following list of QuoRecords within a Customer' subpanel?

product_sn name vendor cost quotation quo_date
0001 mobile nokia 300 400 2010-06-09

You need to include the related fields in the vardefs fro your subpanel module. You can then add them via Studio to your subpanel list view.

For example, I have related Products to Projects, Projects being the child.
I then include in custom\Extension\modules\Project\Ext\Vardefs\varde fs.ext.php


$dictionary["Project"]["fields"]["products_project_name"] = array (
'name' => 'products_project_name',
'type' => 'relate',
'source' => 'non-db',
'vname' => 'LBL_PRODUCTS_PROJECT_FROM_PRODUCTS_TITLE',
'save' => true,
'id_name' => 'products_pf535roducts_ida',
'link' => 'products_project',
'table' => 'products',
'module' => 'Products',
'studio' =>'visible',
'rname' => 'name',
);

The field 'products_project_name' now appears in the Studio.
The above definition will differ depending on whether you used a 'relate' type field or a 1:M relationship, but
the principal is the same.

Rgds
Andrew