I am using the xml capability of sql server 2000. I am trying to insert data using an XSD either through an updategram or the XML Bulk Upload. However, the information goes to two tables. I am using a SQL relationship entity to link the table, but am getting an error message 'the parent/child table of the relationship on 'fdf_xml' does not match.' What am I doing wrong? Below is the XSD:

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
    <xsd:annotation>
        <xsd:appinfo>
            <sql:relationship name="transactionsToFields" parent="imm_fdr_fields" parent-key="transaction_id"
                child="imm_fdr_transaction_information" child-key="transaction_id"/>
        </xsd:appinfo>
    </xsd:annotation>
    <xsd:element name="root">
        <xsd:complexType>
            <xsd:sequence>
                <xsd:element name="fdf_xml" sql:relation="imm_fdr_fields" sql:relationship="transactionsToFields">
                    <xsd:complexType>
                            <xsd:sequence>
                                <xsd:element name="transaction_information" sql:relation="imm_fdr_transaction_information" sql:relationship="transactionsToFields">
                                    <xsd:complexType>
                                        <xsd:sequence>
                                            <xsd:element name="transaction_id" type="xsd:string"/>
                                            <xsd:element name="template_name" type="xsd:string"/>
                                            <xsd:element name="country" type="xsd:string"/>
                                            <xsd:element name="submitted_by" type="xsd:string"/>
                                            <xsd:element name="officer_code" type="xsd:integer"/>
                                            <xsd:element name="sent_date" type="xsd:string"/>
                                        </xsd:sequence>
                                    </xsd:complexType>
                                </xsd:element>
                                <xsd:element name="txtTransactionID" sql:field="transaction_id" type="xsd:string"/>
                                <xsd:element name="txtAccount" sql:field="field1" type="xsd:integer"/>
                                <xsd:element name="txtAmount" sql:field="field2" type="xsd:decimal"/>
                                <xsd:element name="txtCustomer" sql:field="field3" type="xsd:string"/>
                                <xsd:element name="txtNote" sql:field="field4" type="xsd:string"/>
                            </xsd:sequence>
                    </xsd:complexType>
                </xsd:element>
            </xsd:sequence>
        </xsd:complexType>
    </xsd:element>
</xsd:schema>

Never mind. I figured it out.

Dear Yehuda,

I'm having problem in mapping my .xsd file.
I'll appreciate if you can help me since as I saw you dealt with the same problems.

I'll describe my problem:
I'm using SQLXMLBulkLoad to load the xml data

my .xsd schema is:

<xsd:element name="OrderDetail"/>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="CompanyID"/>
<xsd:element name="CompanyName"/>
<xsd:element name="OrderDate"/>
<xsd:element name="Price"/>
</xsd:sequence>
</xsd:complexType>

example xml:

<OrderDetail>
<CompanyID>123</CompanyID>
<CompanyName>ABC</CompanyName>
<OrderDate>2002-10-10</OrderDate>
<Price>100$</Price>
</OrderDetail>

I've 2 tables which I want to update using this xml file:

Table Company:
===========
CompanyID (primary)
CompanyName

Table Orders:
==========
CompanyID (primary, foreign from Company)
OrderDate
Price

I have not succee to put the right mapping.
how do I put the "sql:relation" annotation in 'OrderDetail' when its data should update the two tables in fields that are not the primary-key ? (CompanyName --> Company
and
OrderDate,Price --> Orders)
Best Regards