InfoPath Dev

I'm simplifying my original question: 

How do I map an identity column that is also a primary key in the DAT tool?  I want to create the column on first insert, then retain the original value on subsequent resubmits or writes to database.

still having trouble with this.

I don't understand your question, so here's a quick overview.

There are three main ways to map data from DBXL to SQL. (There may be others, but those are more complex and probably out of the realm of forum support.)

1. Map the DocID and make this the key (in the DAT mapping).

2. Add an autoincrement column in the SQL table and make this the key (in SQL). In DBXL's Database mapping tab, you won't have a row labeled as "key".

3. Have the form generate a unique ID (such as when using SubmitDocumentWithKey or GenerateGuid) and map this to SQL as your key. (this is quite similar to #1, except that in #1 DBXL generates the DocID and in #3 you are generating the key via form rules).

I think the documentation on our website covers all three of these, but let me know if you need help finding those tutorials.

Thank you Ernesto.  I actually recieved paid support from Hilary last friday to figure this out.  I thank you for posting though, I will use this as a guide in the future.  Doreen