Oracle CRM On Demand Desktop Administration Guide > Additional Code in the Customization Example >

XML Code That Defines a Many-To-Many Relationship

Many-to-many relationships are typically defined using association objects. It is recommended that you place these objects in DB FACADE storage by adding the following XML code to the od_basic_mapping.xml file:

<type id="Opportunity.Channel_Partner.Association" icon="type_image:Opportunity.Channel_Partner.Association:16">
    <field id="OpportunityId">

      <type>

         <simple type="binary" />

      </type>

   </field>

   <field id="ChannelPartnerId">

      <type>

         <foreign_key>

            <type_id>Channel_Partner</type_id>

         </foreign_key>

      </type>

   </field>

   <field id="ChannelPartnerStatus">

      <type>

         <simple type="string" />

      </type>

   </field>

</type>