Example Data ------------ fhd_Forms ID FormName LayouColumns CreatedBy Created ModifiedBy -- -------- ------------ --------- ------- ---------- 1 walmart 1 Admin 2005-12-05 Admin fhd_FormFields ("Title" is the question field) ID FormID Type DefaultValue Title Position Selected -- ------ ---- ------------ ----- -------- -------- 21 1 4 Blob Do you Live in a shoe?: 1 0 22 1 4 Blob Is Your Car A Banana?: 2 0 23 1 4 Blob Do you have red shoes?: 3 0 fhd_Records ID FormID DateEntered IP -- ------ ----------- -- 92 1 2006-01-21 67.164.152.45 93 1 2006-02-19 73.23.222.33 fhd_RecordValues (Value is the answer field) ID RecordID FieldID Value -- -------- ------- ----- 1225 92 21 yes 1226 92 22 no 1227 92 23 no 1228 93 21 yes 1229 93 22 yes 1230 93 23 yes -------------------------------------------------------------------------------- | Do you live in a shoe? | Is Your Car A Banana? | Do you have red shoes? | <-- Dynamic header based off of fhd_FormFields -------------------------------------------------------------------------------- | yes | no | no | -------------------------------------------------------------------------------- | yes | yes | yes | <-- results based off od fhd_RecordValues --------------------------------------------------------------------------------