Data structure question - InfoPath Dev
in

InfoPath Dev

Data structure question

Last post 02-14-2012 02:09 PM by Hilary Stoupa. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 02-14-2012 11:32 AM

    Data structure question

    Sorry if there is a fairly easy answer to this that I'm not seeing, but I wanted to get the best practice for what I'm trying to do.

    I have a form that lists several categories in sections on the view.  Each section will be hidden and potentially displayed based on the value selected in another control.  Each of the categories will collect roughly the same data.  Currently, I have structured my datasource so that Category is a group that contains each of these fields like so:

    Category A

    CatA_DataSource

    CatA_Comments

    CatA_Symbol

    Category B

    CatB_DataSource

    CatB_Comments

    CatB_Symbol

    Category C

    CatC_DataSource

    CatC_Comments

    CatC_Symbol

    Seems like there should be a more efficient way to do this such as a repeating table with Category as the identifier, but I'm not sure how to go about this and collect and show the records in the relevant, individual sections.  Does anyone have a better idea on how to approach this or am I already doing it the right way?

    Thanks in advance.

  • 02-14-2012 01:49 PM In reply to

    Re: Data structure question

    OK, I answered my own question.  I followed the steps here to create a repeating table, and then specified the default values for each Category up front to initially build my table.  I added a Y/N field to conditionally display each section of the repeating table and it works like a charm.  Went from 192 fields (12 fields X 16 categories) in my original data structure to 14!

     Sorry if that was InfoPath 101.  

    (c:

  • 02-14-2012 02:09 PM In reply to

    Re: Data structure question

    Hey, sorry you ended up talking to yourself, but thanks so much for following up and posting what you did - you are correct, that is a much better schema!

    Hilary Stoupa

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