 |
 | 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 / July 2008Application Number ?
Everyone, I'm creating a form that needs an indentification number presented on it and I tend to use the autonumbering of one of the primary keys of my Slip_ID column. It will always be unique but I need to somehow get this on the form so they know what slip number they have for reference. My question is, if I'm using SQL 2005, will that number be presented before I submit the data? Thank you Alex Anderson On Jul 22, 5:40 am, Alex Anderson <AlexAnder...@discussions.microsoft.com> wrote: > Everyone, > [quoted text clipped - 6 lines] > Thank you > Alex Anderson Hi Alex, You can show database data on the form without any issues. All you need to do is to have a dataconnection. Do let me know, in case you need any further information. Thanks, Paresh Paresh, I created another data connection to retrieve information and I inserted the field I want to display but the number it shows is the very first record in my database. How do I tell the form, rather that control to fetch the next number in line? Thank you Alex Anderson > On Jul 22, 5:40 am, Alex Anderson > <AlexAnder...@discussions.microsoft.com> wrote: [quoted text clipped - 18 lines] > Thanks, > Paresh On Jul 22, 8:11 pm, Alex Anderson <AlexAnder...@discussions.microsoft.com> wrote: > Paresh, > [quoted text clipped - 30 lines] > > - Show quoted text - I guess for this, you will need to modify the SQL query that you might be using in the data connection method. Thanks, Paresh Often you want to use the Max () function. To get the largest number in the returned set and then +1 to get the next ID number, if they are sequential.  SignatureClay Fox / Microsoft InfoPath MVP www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To, Experts, Forum > On Jul 22, 8:11 pm, Alex Anderson > <AlexAnder...@discussions.microsoft.com> wrote: [quoted text clipped - 38 lines] > Thanks, > Paresh |
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.