• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1307
  • Last Modified:

Infopath repeating section,repeating table

Infopath 2007 using a sql database. I tracking problem cases. When I search by server I can get mutiple repeatinging sections back with case number,server number, date. On each repeating section there should be a repeating table that track multiple lines of history relating to each case. I just can't seem to get the right combination.
repeating section
case number
server number
repeating table
date  user name action taken
date user name action taken
date user name action taken
  • 2
1 Solution
Clay FoxDirector of Business IntegrationCommented:
Not sure if you have data connections to both tables or if you need to also submit a history record.

The key is to create your main repeating section, often using a layout table is best. Then drag in your history and select repeating table.
Put a filter on the history so that it only displays the history that matches the id of the main record.

If this is a child table then it will happen automatically.
tuckcorpAuthor Commented:
thank you. i have tried adding another table to the data coonection from the sql server,i tried adding a second data connection to receive data, but this show everything in the database. the ,closest i came was using a repeating section with the history table placed inside but this showed  all history not just the history for the info specfic to the repeating section.
Clay FoxDirector of Business IntegrationCommented:
You have to use conditional formatting.

On the repeating table add a conditional format
server number != server number then Hide the row

That way only history for that item is shown inside the item.
This is not very performant and it would be better to go into your main data connection and modify.
Use the add table button and select the history table. Then set the relationship on the server ID or whatever.
Then when a query is made, only the associated history will be loaded.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now