This question has been answered by nowhinjing1. See the first response.
<?xml version="1.0" encoding="UTF-8"?> <model package="curconv" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" version="1.0"> <object class="CCbase" table="ccbase" extends="xPDOSimpleObject"> <field key="basecur" dbtype="varchar" precision="3" phptype="string" null="false" default=""/> <field key="updatedon" dbtype="datetime" phptype="datetime" null="false"/> <field key="description" dbtype="text" phptype="string" null="false" default=""/> <field key="symbol" dbtype="varchar" precision="3" phptype="string" null="false" default=""/> <field key="uprate" dbtype="decimal" precision="5,4" phptype="float" null="false" default="0"/> <field key="rnupdn" dbtype="tinyint" precision="1" phptype="boolean" null="false" default="0" /> <field key="rndlvl" dbtype="tinyint" precision="1" phptype="integer" null="false" default="0" /> <field key="appid" dbtype="varchar" precision="32" phptype="string" null="false" default=""/> <field key="upmins" dbtype="int" precision="4" attributes="unsigned" phptype="integer" null="false" default="0"/> <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="createdon" dbtype="datetime" phptype="datetime" null="true"/> <field key="createdby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="editedon" dbtype="datetime" phptype="datetime" null="true"/> <field key="editedby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0" /> <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true"> <column key="basecur" collation="A" null="false" /> </index> <composite alias="CCentry" class="CCentry" local="basecur" foreign="basecur" cardinality="many" owner="local" /> <aggregate alias="CreatedBy" class="modUser" local="createdby" foreign="id" cardinality="one" owner="foreign"/> <aggregate alias="EditedBy" class="modUser" local="editedby" foreign="id" cardinality="one" owner="foreign"/> </object> <object class="CCentry" table="ccentry" extends="xPDOSimpleObject"> <field key="basecur" dbtype="varchar" precision="3" phptype="string" null="false" default=""/> <field key="entrycur" dbtype="varchar" precision="3" phptype="string" null="false" default=""/> <field key="description" dbtype="text" phptype="string" null="false" default=""/> <field key="exrate" dbtype="decimal" precision="10,4" phptype="float" null="false" default="0"/> <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="createdon" dbtype="datetime" phptype="datetime" null="true"/> <field key="createdby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="editedon" dbtype="datetime" phptype="datetime" null="true"/> <field key="editedby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0" /> <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true"> <column key="entrycur" collation="A" null="false" /> </index> <aggregate alias="CCbase" class="CCbase" local="basecur" foreign="basecur" cardinality="one" owner="foreign" /> <aggregate alias="CreatedBy" class="modUser" local="createdby" foreign="id" cardinality="one" owner="foreign"/> <aggregate alias="EditedBy" class="modUser" local="editedby" foreign="id" cardinality="one" owner="foreign"/> </object> </model>
OK got it now ...
For other thickos like me the tip is to read up on nested MigX definitions - the top one for the main table and a subordinate definition for the linked table.
Easy, really but I will produce a simple tutorial to help others as and when I find time.
Just one thing I can't figure out - when you add an item in the linked table how can you pre-populate the link id to the base table ?
There must be a way ....
Bruno, help !