 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / March 2007Order form - 2 data connections question
I use InfoPath 2003. Can I use a data connection to populate a drop down (items available for ordering) and then use a data base connection to store the data submitted in SQL? In other words, two data connections. On top of all this, I want to do this in a repeating table so if the database of items that can be ordered is 50 items, someone could order 1 of each of the 50. Make sense? I hope so Thanks The first data connection would be a "Retrieve data" data connection to a database, so that is possible. But you cannot create a "Submit data" data connection to a database, because there isn't one in InfoPath. You'll have to write code (either ADO or a webservice) to submit data to a database. Have you already walked through the InfoPath labs (http://msdn2.microsoft.com/en-us/office/aa905438.aspx)? I'm not sure I understand your second question, but if you meant whether it is possible to use a drop-down in a repeating table, the answer is yes. Once you've selected an item from the drop-down, that becomes *the value* of the drop-down. So when you submit the form, only the selected value will be submitted. --- S.Y.M. Wong-A-Ton > I use InfoPath 2003. > [quoted text clipped - 9 lines] > > Thanks What if I created a new form based on a database connection to a SQL table which becomes the submit (save) And then created a new data connection for the retreive to populate the drop down. Won't this give me the desired effect? > The first data connection would be a "Retrieve data" data connection to a > database, so that is possible. But you cannot create a "Submit data" data [quoted text clipped - 24 lines] > > > > Thanks That too would work. Thought you specifically wanted to use a submit data connection to a database... --- S.Y.M. Wong-A-Ton > What if I created a new form based on a database connection to a SQL table > which becomes the submit (save) [quoted text clipped - 32 lines] > > > > > > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.