Pete,

I tried to find your original post, thinking that you posted the full error message somewhere, but I couldn't find it. The reason for your error should have jumped out at me if I had seen it when you originally posted (and maybe you *did* post the full error message, but I was brain-dead at the time and it *didn't* jump out at me) ...

Anyway, the problem is case-sensitivity. The PK in your SQL DataSet is "ClaimRef" and it's "claimref" in your Fox DataSet. That's it, plain and simple.

~~Bonnie



>Hello Bonnie, sorry for the delay in sending you this ( in fact I did but it must have failed ! ) but here it is for what it's worth
>
>// SQL Data
>

><NewDataSet>
><PKTABLE>
><ClaimRef>2101012648</ClaimRef>
><CreditorName>Pete Kane</CreditorName>
><PayDetailsID>11479</PayDetailsID>
><PayAddressID>26981</PayAddressID>
><PayDetailsConf>false</PayDetailsConf>
><PayDetailsConfUser>   </PayDetailsConfUser>
></PKTABLE>
></NewDataSet>
>
>
>// Fox Data
>
>−
><NewDataSet>
><PKTABLE>
><claimref>2101012648</claimref>
><claimstatus>05</claimstatus>
><admittedbalusd>255.59</admittedbalusd>
><admitlist>03 </admitlist>
><payblockcode>  </payblockcode>
><article39code>01</article39code>
><article39letterdate>2005-05-20T00:00:00.0000000+01:00</article39letterdate>
></PKTABLE>
></NewDataSet>
>

>
>thanks