https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/8825.aspxWed, 19 Apr 2006 20:44:04 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:8825rjaynes0https://www.infopathdev.com:443/forums/thread/8825.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=8825I'm just a beginner with InfoPath, but here's what I did to get my trouble ticket number field to increment:<br />My main data table in Access has a primary key field (my ticket ID number).<br />I have a textbox bound to this field in my InfoPath form. (With my main data table set up as the primary data source.)<br />I have a secondary data source set to query data that is also linked to this same table, and I am pulling only the ticket ID number from it.<br />In the textbox properties, I have a formula set up as follows:<br />max(@Ticket) + 1<br />The "@Ticket" is the ticket ID field from the secondary data source.<br />I have left the "Update this value when the result of the formular is recalculated" checkbox empty.<br />Now, when I go to preview or actually run the ticket, my Ticket # field displays a new ticket number, because it is adding 1 to the highest number is found to already be in the table.<br />The ONLY catch I've run into is that if there is nothing already in the database, I get an invalid data error because there is not even a zero in that field technically, so InfoPath doesn't know how to increment nothing by 1. To get around this I have added the first ticket (as a test ticket) and that solved my problem temporarily, but I haven't figured out how get around that the "right way". I would assume if you wanted to start with a specific number you could just directly add one into the database, unless it already existed then it shouldn't be a problem. Hope I have helped and have not been totally confusing. If anybody else knows of any problems with my setup please let me know because I am currently in the testing portion of my design. Thanks a bunch!<br />Ryan<br /><br />https://www.infopathdev.com:443/forums/thread/8824.aspxWed, 18 Jan 2006 02:40:14 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:8824Matt Faus0https://www.infopathdev.com:443/forums/thread/8824.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=8824Please see this thread:<a target="_blank" href=http://infopathdev.com/forums/topic.asp?TOPIC_ID=1558>http://infopathdev.com/forums/topic.asp?TOPIC_ID=1558</a><br /><br />---------------<br />Matt Faus<br />InfoPath Dev Texas<br />https://www.infopathdev.com:443/forums/thread/5274.aspxMon, 16 Jan 2006 21:02:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:5274lisaspencer0https://www.infopathdev.com:443/forums/thread/5274.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=5274Hi! I am trying to create an automatic number field that starts at 531. It's for a ticket support form. I need to program a text box field to increment everytime a new form is created, otherwise if a ticket is just opened not to do anything. I am using VBScript. The form is connected to an Access Database. Thanks,<br /><br /><br />Lisa Spencer<br />Programmer/Office Specialist