Creating a foreign key database mapping for my repeating tables - InfoPath Dev
in

InfoPath Dev

Creating a foreign key database mapping for my repeating tables

Last post 10-28-2010 05:59 PM by Jim Cantwell. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 09-14-2010 05:42 AM

    Creating a foreign key database mapping for my repeating tables

    Hi it's me again...

    I have some repeating tables in my form which I use to hold billing dates and amounts. The objective is to store these data into another database table which is linked to my form master table. I suppose the right way is to use a foreign key to link my two tables? Using this concept, I also mapped my form data to database using Qdabra's database mapping tab as seen in my attachment. I was able to save so I hope I got it right?

    The problem now is that when I see my shredded documents, only the first repeating table row is shredded. By right, I have two rows of billing data but how come only one row got shredded? Can someone advise me if I missed out some settings? Group4 is my repeating table's repeating row while Billing_Date and Amount are my field values.

    Thanks alot again!


  • 09-14-2010 08:26 AM In reply to

    Re: Creating a foreign key database mapping for my repeating tables

    Hi -- if Group4 is your repeating group, you should map your table to Group4, then map the fields. Currently, your mapping will only get the first item in the group.

    Hilary Stoupa

  • 10-28-2010 05:59 PM In reply to

    Re: Creating a foreign key database mapping for my repeating tables

    Were you able to resolve your problem?

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.