Creating a Matrix vs a simple repeating table in InfoPath

[Shawn]

I'm new to InfoPath - I'm recreating several excel spreadsheets in infopath.
I'm using SQL as my backend. I would like to create an entry table where the
end user can enter an employees role down the far left column and an Activity
accross the top and then a responsibility code would be entered in the field
where the two meet. Several Role/Activity possibilities exist. I need to
allow the user to enter the responsibility and add to the Role and activity
fields.

Thanks
Shawn

 

[Franck Dauché]

Hi Shawn,

You may want to look into Repeating tables with drop-downs as cells. The
drop-down content could be fix or could come from SQL Server through
secondary data sources.
However, your columns will be fixed. Your users won't be able to add
columns on the fly.

Maybe you could rethink the table (if you can change the design). with
master/detail tables (master = employees / detail = activities).

Regards,

Franck Dauché