tuckcorp
asked on
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
date
issue
___________________
repeating table
date user name action taken
date user name action taken
date user name action taken
_____________________
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
_____________________
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER