Hi,
I have a DCR with data either for Channel Or Dealer.If there is data entered for Channel it goes to Channel table or If data entered for Dealer it goes to Dealer table but not for both.
In my configuration file how i can tell above situation
<group name="Channels" table="CONTENT_CHANNELS" root-group="no">
<attrmap>
<column name="CONTENT_ID" data-type="NUMBER" value="1" allows-null="no" is-url="no"/>
<column name="CHANNEL_CODE" data-type="VARCHAR(10)" value="C11" allows-null="no" is-url="no"/>
<column name="CREATED_DATE" data-type="DATE" data-format="MM-dd-yy" value-from-field="Expiration_Date" allows-null="no" is-url="no"/>
<column name="CREATED_USER_ID" data-type="VARCHAR(20)" value-from-field="Author" allows-null="no" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="CONTENT_ID"/>
<key-column name="CHANNEL_CODE"/>
</primary-key>
</keys>
</group>
<group name="DEALERS" table="CONTENT_DEALERS" root-group="no">
<attrmap>
<column name="CONTENT_ID" data-type="NUMBER" value="1" allows-null="no" is-url="no"/>
<column name="DEALER_CODE" data-type="VARCHAR(10)" value="D11" allows-null="no" is-url="no"/>
<column name="CREATED_DATE" data-type="DATE" data-format="MM-dd-yy" value-from-field="Expiration_Date" allows-null="no" is-url="no"/>
<column name="CREATED_USER_ID" data-type="VARCHAR(20)" value-from-field="Author" allows-null="no" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="CONTENT_ID"/>
<key-column name="DEALER_CODE"/>
</primary-key>
</keys>
</group>
I am just confused. If i entered Channel information How i can avoid dealer table.
Thanx in advance
