InfoPath Dev

Thanks Hilary, I forgot to put on the previous comment that I am unable to add in an "id" field on to the Secondary Database Connection ... Also thanks for the help and you time so far Hilary and donStephen

The problem with that approach is that I am trying to submit into a database table, meaning I am unable to add the "count" and "lastitem" fields .. which are needed :( Unless there's a way to submit user created fields into the database table?

Thanks donstephen, but I do not have qRules, is there any way to do it without?

I am having trouble copying data from my secondary data connection into my main data connections repeating table, below is my code for adding an item to my main data connections repeating table: Private Sub AddItem( _ ByVal Car As String) Dim doc As XmlDocument = New XmlDocument() Dim group As XmlNode = ...

I'm trying to use the second approach that uses the qRules' Insert command, but I am having difficulty getting it to work. Maybe its because I am using a database as the main connection instead of an XML connection? I've attached my InfoPath form with the QdabraRules inside the form. Would really appreciate it if you could have a ...

Thanks for the reply donstephen, could you please resend that form in InfoPath 2007 :)

Thank you for your help donstephen, but I was looking for the secondary data source fields to be submitted into the main data connection into separate records, not one large concatenated entry, please see the attached example of what I am trying to do. Basically trying to copy the fields in a secondary data source like for like and submitting ...

Thanks donstephen, the approach is what I am looking for, however I need to populate the same field multiple times from the Secondary data source.

Thanks for your reply donstephen, just to answer your question my button is located within the repeating table, I am however unable to open your sample form as I only have InfoPath 2007 SP3 to work with. The code is: Public Sub CTRL151_4_Clicked(ByVal sender As Object, ByVal e As ClickedEventArgs) Dim secDSNav As XPathNavigator = ...

I am trying to populate My main table which only consists of one field from a secondary table automatically when a button is pressed. It is throwing up an error on this line: MainDataSource.CreateNavigator().SelectSingleNode( _ "/dfs:myFields/dfs:dataFields", _ ...