Order form - 2 data connections question

A

Art

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
 
S

S.Y.M. Wong-A-Ton

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.
 
A

Art

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?
 
S

S.Y.M. Wong-A-Ton

That too would work. Thought you specifically wanted to use a submit data
connection to a database...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top