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.

Hi! I have the following business requirement: We have an InfoPath form published to a SharePoint library, and when this form is submitted to the library (after going through an approval workflow), it needs to create a new record in a table in a backend database. the table at the backdend database has...

Here is my scenario: I have created a Timesheet form in Infopath 2010 that has a receive data connection to a SQL database, which I set up through DBXL. The SQL table my form is connected to contains a hierarchy for my company. In the form, I have a dropdown box that lists all of the Employee ID Numbers...

I am moving my MOSS 2007 databases to a new sql server tomorrow. I also have Qdabra DBXL installed to the sql server. My sharepoint web server is on a different machine. The sql server version (2005) is staying the same, but the operating system is changing from 2003 to 2008. What are the best steps...