OK I have a form with two views. View 1 (Office View) links to an Access database. View 2 (Pit View) contains text boxes. I am using Pit View to create a print version with the SDK. Office View pulls data from Pit View to be posted back to the database for reports and billing.
My problem is in my repeating sections. I need the count or position of the repeating section on Office View so I can reference the fields in Pit View. My count(preceding-sibling::T2) + 1 in Pit View works but does not work in Office View (yes I reference the corresponding repeating section in Office View). I can use an Expression Box in Office View to calculate the data I need with position() but I cannot reference that data. It seems nothing works when my fields are linked back to the Access Database.
I will be referencing the data from Pit View for Office View such that OfficeView.RepeatingSection[x].DataField = PitView.RepeatingSection[x].DataField for all data fields and all sections. Any suggestions.