I have a one to many relationship between table A->B, A->C, and A->D. More specifically the entities are A-CourseOffering, B-FCE, C-FCE_INS and D-FCE_TA. Now I am trying to display data from FCE, FCE_INS, and FCE_TA. So consider the primary key for A is, course_No, semester, section and SEQ_NO. So for each combination of these values there are many records in each of the tables mentioned.
Now when I am displaying this info, I am using rich:dataGrid to iterate through the list and display it, since I have static text questionnaire for each of the columns of the tables(FCE, FCE_INS, FCE_TA). So for example, other than the primary key, if FCE has 7 columns, then there are 7 questions and each question will have a radiobutton selected for the answer in that respective column. Hopefully this clears how I am trying to display the page.
The point is I need to iterate simultaneously through the three arraylists, FCE, FCEINS, and FCETA and display according to the sequence no on each page.
I use the rich:dataGrid to iterate through the lists. I use a rich:dataScroller for paging. The problem is that I am able to iterate through the first list FCE, and the first row data appears on the first page, the second row on the second page, and so on and so forth.
But right below that if I am trying to display the first row data of FCE_INS and FCE_TA on the first page, and second row data on the second page, it is not coming.
HOW DO WE ITERATE SIMULTANEOUSLY THROUGH THREE LISTS AND DISPLAY FIRST ROW DATA IN THE FIRST PAGE, and SECOND ROW DATA ON THE SECOND PAGE.