Data Connections

Re: Question about repeating connections

Hilary Stoupa — Tue, 19 Aug 2008 22:16:23 GMT

When you relate your tables in the data connection, you create the relationship between the tables. Your tables, in your database, should have a key that relates them. For example, your parent table might have a column called ServerID. Your child table would have a column called ServerID as well, and each row in the child table would contain the server id of the parent table.

Try this -- after making sure you have appropriate table relationships in SQL for your tables, create a new form off the database. Connect your tables in data connection. Grab the folder from the data source that contains both tables, and drag it over to a blank view and create a new section with controls. Seeing how InfoPath sets things up when you let it decide may help you see how to set them up on the form you've already created.

Re: Question about repeating connections

ybotspawn — Tue, 19 Aug 2008 20:54:41 GMT

Currently the form is bound to my base table. Would I want the sub table connected to my base table instead? How would I then be sure I know which drive letter was associated with which server request? For example:

server request: server1
<connects to base table>

drive letter: G
drive size: 40gb
drive letter: H
drive size: 20gb
<connects to sub table>

how do I make the relationship that connects the two requests and says that both g and h are for server1, not the next server submitted? Did I understand you correctly? Thanks!!!

Re: Question about repeating connections

Hilary Stoupa — Tue, 19 Aug 2008 20:39:07 GMT

Hi--

Is your repeating table bound to the new sub table you created? In order for your form to send data to your data tables, you'll need to make sure your controls are bound to the fields that are associated with your tables. If you haven't already seen this article, it may help you.

Re: Question about repeating connections

ybotspawn — Tue, 19 Aug 2008 20:26:43 GMT

Ok, so I created the sub table, in SQL, but other than a foreign key relationship, that doesn't seem to do what I am asking for, there are no other options? Anyone?

Re: Question about repeating connections

ybotspawn — Mon, 18 Aug 2008 21:04:44 GMT

So I would add a subtable in the sql database or would I add it into the infopath page? Thanks in advance!

Re: Question about repeating connections

Clay Fox — Wed, 13 Aug 2008 06:39:06 GMT

Any data you want in the database must be put in the DB.

You may need a sub table relationship for the additional repeating section.

Other fields added to the form do not go to the DB unless they are existing fields.

Question about repeating connections

ybotspawn — Thu, 07 Aug 2008 17:55:07 GMT

Ok, so I created a new form that dumps all the form data into a sql db. I have also created a repeating section, as this is to be used to request drive space and drive letters attached. As different groups in my organization have different requirements regarding drive name, I have provided the ability to do a repeating section so that they can add drive letters and requested sizes as necessary. Why do these not show up in the db? Do I need to add extra fields for these? Can someone give me a hand? Thanks!