InfoPath Dev

Ok, so I've written some c# code that queries a sql database for the next available ticket number.  My c# code returns the latest ticket number + 1.  How do I configure my form so that the ticket number textbox is set to the return value of my code?

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

 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?

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

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