Xref repeat tbl to sngl flds in rpt section?

S

Sherlock

How can I build a summary table at the end of my IP2003 form that shows the
responses earlier in the form in a condensed, tabular format? If I were
working with similar types of controls, I could just bind both the entry
fields and the summary fields to the same data sources, but it isn't that
easy.

In the entry section, I have single fields within a repeating section. The
section can be inserted any number of times.

In the summary section, I had planned to use a repeating table. However, I
can't figure out how to sync the single fields in the repeating section in
the entry section to the repeating table fields in the summary section.

The reason I was taking this approach is that the questions in the entry
section involve a lot of explanation for the user and also are sometimes
optional (and therefore hidden), based on the user's input. There wasn't room
to do all that in the tabular format, but the tabular format provides a good
snapshot of the choices made.

Is this even possible?

Thanks.
 
K

Kalyan G Reddy MVP (GGK Tech)

Hello

You should use Master/Detail Control to work out your scenario
The summary section would be your Detail and the Entry fields will be in
your Master section
 
S

Sherlock

Thank you, Kalyan. I haven't worked with the master/detail controls before,
so it will take some studying. It's difficult to picture how a repeating
master would feed the detail, but I'll work with it and then maybe I'll
understand it better. Thank you for pointing me in that direction. No one
else was even able to offer a suggestion as to how to approach it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top