Hi all,

I need to find a way where a user can enter data for a matrix build
automatically(somehow) based on two columns of fields(field1 and field2).  
The field1 data and field2 data can come from another view of the form.  From
those two repeating fields I want to make a matrix based on that and have
user entered the third field(for each field1 crossing field2).  At the end,
field1 and field2 data will be used to fill another part of the schema.

Here is an example.  Schema looks like

RepeatingGroup1
 field3
 field4
 field5

The matrix will look like the following:
         field2[1] field2[2] ...
field1[1] x11       x12
field1[2] x21       x22
field1[3] x31       x32
...

Result is as follows:
field3    field4   field5

field1[1] field2[1] x11
field1[2] field2[1] x21
field1[3] field2[1] x31
field1[1] field2[2] x12
field1[2] field2[2] x22
field1[3] field2[2] x32

I am having lots of trouble trying to think of the a way to build this so a
user can enter data for this matrix.  There are two issues I found here.  The
first one is the fact that the number of rows for field1 and field2 are
undetermined.  If needed be, I can use a limit number to represent the
maximum number of rows or columns.  The second issue is the fact that I might
have to build a repeating table of some sort to let the user to fill in x
values.

Please advice on this issue.  In Excel this is easy, but I realize in
InfoPath there is no easy control like a grid that can handle such things.  
But if there is tips or tricks, please let me know.  Any comment would be
greatly appreciated.

Thanks,
Michael