Bryant Likes

Hi,
<br>I am using Bulkload to upload multiple relational tables, one table with Autoincrement PK. It worked fine. Now I need to Add a child table to it which has the Same PK field and has to be loaded from the parent.
<br>
<br>Here I have scores table, whose Score_ID feild is autogenrated. I need to populate another TblScoreHistory table with scoreID and omr_scores fields. I tried with the relationship specifiled but didn't work. How do I define my Schema.
<br>
<br>Thanks
<br>
<br>
<br>MY datafile
<br><Score editflag="0">
<br> <omr_score>*</omr_score>
<br> <ScoreHistory>
<br> <OrigScore>*</OrigScore>
<br> </ScoreHistory>
<br></Score>
<br>
<br>
<br>
<br>-------------------------
<br>
<br>My Schema
<br><sql:relationship name="ScoresScoreHistory" parent="scores" parent-key="score_id" child="tblScoreHistory" child-key="ScoreID"/>
<br>
<br><xsd:element name="Scores" minOccurs="0" sql:is-constant="true">
<br><xsd:complexType>
<br><xsd:sequence>
<br><xsd:element name="Score" minOccurs="0" maxOccurs="unbounded" sql:relation="scores" sql:relationship="BookletPageScores" sql:key-fields="score_id">
<br> <xsd:complexType>
<br> <xsd:sequence>
<br> <xsd:element name="score_id" type="xsd:integer" minOccurs="0"/>
<br> <xsd:element name="omr_score" type="xsd:string" sql:field="omr_scores"/>
<br> <xsd:element name="ScoreHistory" minOccurs="0" sql:relation="tblScoreHistory" sql:relationship="ScoresScoreHistory" sql:key-fields="score_id">
<br><xsd:complexType>
<br> <xsd:sequence>
<br> <xsd:element name="scoreid" type="xsd:integer" minOccurs="0" sql:field="scoreID" sql:mapped="true"/>
<br><xsd:element name="OrigScore" minOccurs="0" sql:field="vcscanvalue" sql:mapped="true"/>
<br></xsd:sequence>
<br></xsd:complexType>
<br></xsd:element>
<br></xsd:sequence>
<br></xsd:complexType>
<br></xsd:element>
<br></xsd:sequence>
<br></xsd:complexType>
<br></xsd:element>
<br>