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 -- Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
