General

Re: Data structure question

Hilary Stoupa — Tue, 14 Feb 2012 22:09:38 GMT

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!

Re: Data structure question

milhouse11 — Tue, 14 Feb 2012 21:49:42 GMT

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:

Data structure question

milhouse11 — Tue, 14 Feb 2012 19:32:38 GMT

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.