InfoPath Dev

Being a NON coder, I was wondering if someone could point me to a source of common code snippets for use in Infopath Forms..     In particular I am looking for a piece of code that I can tie to the "NEW RECORD" button that:  

1) Opens a SQL DB file data source, reads a master number

2) Increments the master number by 1 and writes it back, closes the file.

3) places the number read into a field on the form to be submitted into the main datasource on a submit

 any help on this would be greatly apreciated...

 

Thanks

 

Scott haigh

 

Hi Scott.

 To do this does not require code but it does require Web Services, which give you the ability to both query and submit to multiple tables. Check out the Database Accelerator which gives you a whole suite of web services to use. Qdabra Database Accelerator Suite Version 2.1.2815 - Developer

 With this you can increment your master number in the form load and then use it in your additional table entry.  If you need help or a demo just let me know.