Hi!, I'm new with Infopath and I want to design a form which display data obtain from a database in a horizontal view. Example:
I have 3 tables: Projects, Cells and Categories. The Projects table contains: IdProject, ProjectName, TotalBase and IdCategory. Cells table contains: IdCell, CellName, TotalCell and IdProject. Finally, Categories table contains: IdCategory and CategoryName.
I want to display data in Infopath like this view:
ProjectName TotalBase CellName1 TotalCell1 CellName2 TotalCell2 ...
Notice that each project may have more than one cellname.
I've only achieved to display data with this format:
ProjectName1 TotalBases CellName1 (one row per namecell)
ProjectName1 TotalBases CellName2
ProjectName1 TotalBases CellName3
ProjectName2 TotalBases CellName1
It is possible to display data like I need?
Thanks for your help,
Ivan.