Solved

Infopath repeating section,repeating table

Posted on 2010-11-08
3
1,291 Views
Last Modified: 2012-05-10
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
date
issue
___________________
repeating table
date  user name action taken
date user name action taken
date user name action taken
_____________________
0
Comment
Question by:tuckcorp
  • 2
3 Comments
 
LVL 28

Accepted Solution

by:
clayfox earned 500 total points
ID: 34083875
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.
0
 

Author Comment

by:tuckcorp
ID: 34086478
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.
0
 
LVL 28

Expert Comment

by:clayfox
ID: 34086511
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.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now