Is it possible to use a DocID for SQL/SP integration that is not the DBXL:DocId field? I have an electronic purchase order that has an already established PK (the PO Number). I'd like to use this as my PK for the form if possible but the instructions in Module #2 - Map Your Form Data into SQL seem pretty specific to use DocId. Is it possible or does it have to be the DocId?
Thx,
Rob
As long as you have a unique key, it can be anything. It does not need to be the DocID.
The DocID, in fact, does not need to be mapped at all if you have some unique key in your form's data.
Hope this helps!
Thanks Ernesto, I'll give that a try. :) My form is an electronic purchase order and my Database has a Stored Proc that generates a unique PO number with a string prefix (e.g. PO34421) every time a new form is created so I'll see if I can use that string.R.