R
ridawg
Hey,
I would like to create a InfoPath form that would be used to track info
regarding forms (forms we use with our products) that our company uses. Some
of these forms we create and others are created externally. Here's the issue
- for forms created internally I need to generate a unique form number and
the forms created externally already have a number assigned to them.
This was my thought as far as a solution. I would create an Access database
table to store info about each form. Info for both internal and external
forms need to be stored in the same table. Next I would have another table in
my database for internal forms only that would consist of an autonumber. My
thought was in InfoPath when a user goes to enter data about a new form when
they select "Internally" from the Developed By field a button Get Form Number
would become available. They would click this button and a submit would take
place against my second table where I've set up the autonumber. The new
number would be returned to the form number textbox then the user would
submit the completed InfoPath form to my first table.
Hope this makes sense. I'm not sure how to do 2 database submit actions in 1
form. My guess is I will need to write code for one of the submits. I've
never done this so I'm hoping somebody can help me out with an example or
two. I've written a little vbscript before so vbscript examples are preferred.
Thanks!
I would like to create a InfoPath form that would be used to track info
regarding forms (forms we use with our products) that our company uses. Some
of these forms we create and others are created externally. Here's the issue
- for forms created internally I need to generate a unique form number and
the forms created externally already have a number assigned to them.
This was my thought as far as a solution. I would create an Access database
table to store info about each form. Info for both internal and external
forms need to be stored in the same table. Next I would have another table in
my database for internal forms only that would consist of an autonumber. My
thought was in InfoPath when a user goes to enter data about a new form when
they select "Internally" from the Developed By field a button Get Form Number
would become available. They would click this button and a submit would take
place against my second table where I've set up the autonumber. The new
number would be returned to the form number textbox then the user would
submit the completed InfoPath form to my first table.
Hope this makes sense. I'm not sure how to do 2 database submit actions in 1
form. My guess is I will need to write code for one of the submits. I've
never done this so I'm hoping somebody can help me out with an example or
two. I've written a little vbscript before so vbscript examples are preferred.
Thanks!