InfoPath Dev

Here is what I am trying to do-
My form contains a repeating Table with 3 feilds. Feild one is a autonumber incrementing by 1 (ie 1001,1002,1003...) Feild 2 is a Pull down used for a Document selecting,It connects to the sql database and extract documents names. Feild 3 is a Pull down feild
to Select users. This form is a way to assign partnumbers to documents in sharepoint document libraries.

SQL.
Sql datadase is connected to sharepoint to which it stores all of the documents in Document Libraries. I know how to access.

I want to be able to connect to the sql database and insert the partnumber assigned by the form to the document selected from the sql database.

Kip Bautista
KTB Dezines
KTBDezines@netscape.net

Hi Kip,
Why are you adding 3 posts for this. One ought to do no? Anyway, I am a bit confused by your description. I assume you are trying to connect to SQL form the InfoPath form and write the partnumber to a column in a row in a table in the database. Is that correct? Do you have a relational schema for your SQL database? How are you creating a relational database for this project? Have you looked at our Database Accelerator. It will allow you to save data to SQL and use it as a store for all of your forms. I look forward to hearing more from you about your problem.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Sorry for the multiple post I did'nt know where to post.

your assumsion was correct. The database is connected to sharepoint,
the form is then connected to the user data table, it allows me to filter and retrieve all document names from all doc libs in a shrepoint site.

the trick is the get that assigned number into the user data table and connect it to the document selected in the form.

The Relational schema is created as a sharepoint custom intergration plugin.when documents are added to the libraries metadata from the document is placed into the sql db, I use the document apps SDK's to expose metadata I need to put into the userdata table.



Kip Bautista
KTB Dezines
KTBDezines@netscape.net