W
wjasonstrutz
Two questions.
(1) I'm developing a form for expenditure requests that connects to an SQL
database. The form also submits to a Sharepoint form library, providing easy
access to previous requests. I was wondering if anyone had any thoughts on
whether or not the form library is redundant; on one hand, it's pretty easy
to maintain and you can create views in Sharepoint to make searching for a
particular request easy. On the other hand, the data is duplicated, and
changes to the database or to the form library have to be carefully synched.
Most if not all the desired functionality of the form library can be repeated
with a data view web part, or by setting up query fields in the Infopath form
itself, but the form library option would take less development time.
(2) One feature I'd like to include with the request form is to submit an
existing request as new, so commonly ordered items could be submitted as new
requests over and over again with little effort. Since the form uses a
database backend, though, I can't figure out how to make Infopath send an
Insert instead of an Update when existing data is submitted as new (a
separate button from Submit). One possibility is to use ADO in script, but
there are a lot of fields, and I don't want to have to specify each one. Any
ideas?
Thanks,
jason.
(1) I'm developing a form for expenditure requests that connects to an SQL
database. The form also submits to a Sharepoint form library, providing easy
access to previous requests. I was wondering if anyone had any thoughts on
whether or not the form library is redundant; on one hand, it's pretty easy
to maintain and you can create views in Sharepoint to make searching for a
particular request easy. On the other hand, the data is duplicated, and
changes to the database or to the form library have to be carefully synched.
Most if not all the desired functionality of the form library can be repeated
with a data view web part, or by setting up query fields in the Infopath form
itself, but the form library option would take less development time.
(2) One feature I'd like to include with the request form is to submit an
existing request as new, so commonly ordered items could be submitted as new
requests over and over again with little effort. Since the form uses a
database backend, though, I can't figure out how to make Infopath send an
Insert instead of an Update when existing data is submitted as new (a
separate button from Submit). One possibility is to use ADO in script, but
there are a lot of fields, and I don't want to have to specify each one. Any
ideas?
Thanks,
jason.