InfoPath Dev

Hi Hilary, I understand now.  However i'm having a problem with the Create Procedure statement. I created a new test database for this with two columns, 1 is called ID (primary key - autonumber) and the 2nd called TransNumber.  The table itself is named "Trans".  In order to create the stored procedure, I created a ...

Basically, for the query part, I dont really understand what u mean when u say: "If you are storing your Ids in SharePoint or SQL, you can always run a query to retrieve the Ids and use a formula like Max(Id field) +1" Thanks again Fred

Hi Hilary thanks alot for the quick reply, and I really enjoyed your blog post :)), however sadly I do not have a sharepoint license in my office :(( There will be only one person using this form.  Since I do not have a Sharepoint lisence in my office currently, I am using SQL only (Access DB).  I was able to create a ...

Hi, I was hoping to get some help.  I'm currently designing a custom purchase order form, and want to do the following:  1. When the user loads the form, I want infopath to generate an ID (i.e TRANS2009001). 2. I created a drop down list that connects to an SQL database (Access) with a list of all our suppliers.  I was able ...