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