 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / September 2005UniqueID as primary key in Infopath
I would like to autogenerate a UniqueID as the primary key in an SQL database. The dilemma I have that primary keys are required fields and unless I have an entry in this field in infopath I can not submit the form. Any clues? Arved can't you just not include this field in your database connection, and set the column as identity on the db, then when the record is added to the db the field will increment. > I would like to autogenerate a UniqueID as the primary key in an SQL > database. The dilemma I have that primary keys are required fields and unless [quoted text clipped - 3 lines] > > Arved Thanks for your help. The problem is that a primary key is a required field. I therefore can not submit from infopath to sql without entering a value. Thanks IT PHYTOSAN > can't you just not include this field in your database connection, and set > the column as identity on the db, then when the record is added to the db the [quoted text clipped - 7 lines] > > > > Arved Hi, Can't you then do the other way around? remove the ID from your data connection. This way, IP won't know anything about you unique ID. When you submit your form, a new row with be created and a new ID will be assigned by SQL Server. If all your fields are blank (in IP), the form can be closed without being submitted. Franck Dauché > Thanks for your help. The problem is that a primary key is a required field. > I therefore can not submit from infopath to sql without entering a value. [quoted text clipped - 14 lines] > > > > > > Arved Wow, great idea. I'll get right to it and let you know how it went. IT PHYTOSAN > Hi, > [quoted text clipped - 24 lines] > > > > > > > > Arved |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.