I am trying to post data to the receivepaymentline table using an append query in MS Access. I have not been succesful in getting any new data into this table. I have received a lot of different errors like "Error parsing complete XML return string. (#10052). I have read in previous posts that this is usually caused by not having the columns in the correct order (mine are in the correct order).
One of the issues that I may be running into is that related to the three fields in this table which are required when inserting data:
The required fields as i understand it are:
CustomerRefFullName
customerRefListID
appliedToTxnTxnID
I have figured out where to get the first two, but can not figure out where the appliedToTxnTxnID comes from. Can anyone direct me to where I can get the value for this required field?
|