>
>I have at last succeeded in getting it to create a new record in customer table. If I populate the iCust_id field with a valid unique key and skip off the record, I then get the "field x cannot accept null value" as you did. The fields for which it does this as: iMedia_id, cAcct_ref, lCorp_Indiv, yCredit_Limit, yCredit_Balance, iCurrency, iStatus and iVat_Status. If I fill all of these in, then my record gets inserted in the customer table. I can see no link whatsoever between these fields. They are not all indexed, they are of varying types, they don't all have default values. What on earth is going on here??

Its like my last message - you don't enter any values into the fields, hence they aren't class as modified and therefore not sent to the back end.

Change the update type to send all Updatable fields - that will solve it

Ian