Submitting fields to main connection from secondary connection

C

Chris

Hello,

I'm pretty new to InfoPath 2003 SP1 so apoligies if this is pretty basic.
I'm creating a form to log changes against confiurations in our CMDB
(basically a db with all servers, ws etc..). I have a main connection to an
SQL database table to store the changes:
ITEM
AFFECTEDUSER
DATE1
DATE2
etc

I then have secondary connection setup to an SQL view which queries a oracle
DB (our CMDB) and returns a list of servers in field ITEM_SC.

What i would like to do is query the secondary data source which then brings
back all the servers and then uses the ITEM_SC to populate the ITEM field to
submit to the main data source. I try setting the value of ITEM to ITEM_SC.
When I do this i can return all the server names to ITEM_SC but ITEM takes
the first servername in the list and just repeats this name. What i'm trying
to do is create multiple records in the main connection from the secondary
connection.

I have re-read the above and it sounds confusing but i can't explain it any
clearer.

Any help would be well appreciated!
Chris
 

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

Similar Threads

Secondary (receive) data connection with File Attachment 1
Secondary Data connection 1
Populate a field from a Secondary Data Connection from a query valueof a dropdown list 3
Query SQL Secondary data source 3
Programmatically Update Secondary Data Connection Sharepoint List 5
IP03, Refreshing Main Data Connection, OnLoad 0
Submit to SQL database (via webservice) using secondary dataconnection ! 1
Rich Text Box using Secondary Data Connection and to Keep Format 1

Top