On Fri, 2008-09-26 at 09:23 -0700, Dianne Yumul wrote:
If the structure of each report did not differ this would work great
but unfortunately it does.
Diane-
Would an EAV model work? I'm thinking something like <form,field,value>. For example:
formA,ckbox1,true
formA,input1,initial value
formB,textarea1,enter your long comment here
You could easily extend this to <user,form,field,value>, or normalize it as you see fit.
Another possibility is to use hstore hashes for form fields/values. See
http://www.postgresql.org/docs/8.3/static/hstore.html Do either of those suffice?
-Reece