Creating a InfoPath matrix form

OrangeJuice — Mon, 18 Dec 2017 11:06:54 GMT

I need to be able to collect user information that is dynamic in both x and y axis. From a database I want to list students on the left (variable quantity) and subjects on the top (variable). In the cells I want to collect either Pass, Merit or Distinction from a drop down. On the right of every row I want a checkbox to distinguish completed row (record). Below the form I would submission button to create/update the multiple records. So I would create multiple records in the database. If the form is re-opened I need all the information to be pre-populated.

I finally want to hook this up to a Nintex workflow that creates/updates entries in a database.

Any ideas on how to achieve this in InfoPath 2010 and is there a better/simpler option?

Thanks

General

Creating a InfoPath matrix form