I have 2 tables: Form and FormItem. The FormItem table has a FormItemID (PK), FormID (FK), Name, and Value. I'm using InfoPath 2010 with SQL Server 2008 R2 to create forms so the users can view/update the data. So basically, I have a Form that has many FormItems (that are really just name-value pairs).
I want to design an InfoPath form ...