https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/7613.aspxSun, 04 Sep 2005 15:52:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:7613Kiptodd0https://www.infopathdev.com:443/forums/thread/7613.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=7613Sorry for the multiple post I did'nt know where to post.<br /><br />your assumsion was correct. The database is connected to sharepoint,<br />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.<br /><br />the trick is the get that assigned number into the user data table and connect it to the document selected in the form.<br /><br />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.<br /><br /><br /><br />Kip Bautista<br />KTB Dezines<br />KTBDezines@netscape.nethttps://www.infopathdev.com:443/forums/thread/7612.aspxSun, 04 Sep 2005 05:30:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:7612Patrick Halstead0https://www.infopathdev.com:443/forums/thread/7612.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=7612Hi Kip,<br />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.<br /><br />Patrick Halstead [InfoPath MVP]<br />InfoPathDevhttps://www.infopathdev.com:443/forums/thread/4893.aspxSat, 03 Sep 2005 15:02:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:4893Kiptodd0https://www.infopathdev.com:443/forums/thread/4893.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=4893Here is what I am trying to do-<br />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<br />to Select users. This form is a way to assign partnumbers to documents in sharepoint document libraries.<br /><br />SQL.<br />Sql datadase is connected to sharepoint to which it stores all of the documents in Document Libraries. I know how to access.<br /><br />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.<br /><br />Kip Bautista<br />KTB Dezines<br />KTBDezines@netscape.net