1 Reply Latest reply on Jul 21, 2010 5:22 AM by GSNet

    Single headers for multiple repeat regions

    bodywise02 Level 1

      hello,

       

      I am stuck.   I have a Dreamweaver version 8.0 repeat region based on one recordset.   I am trying to develop a routine where individual and unique headers will separate each category.   This is a laboratory value database where I want to separate various components with associated labels.

       

      Currently,  and schematically the MySQL database looks like this:

       

      header:

      date,  labcode, value, abnormal values.

      date,  labcode, value, abnormal_flag.

      date,  labcode, value, abnormal_flag.

      date,  labcode, value, abnormal_flag.

      ...

       

      I wanted it to display as follows conditionally labeled according to the labcode.   

       

      hematology

      date,  labcode, value, abnormal_flag.

      date,  labcode, value, abnormal_flag.

      date,  labcode, value, abnormal_flag.

      date,  labcode, value, abnormal_flag.

      ....

       

      chemistry

      date,  labcode, value, abnormal_flag.

      date,  labcode, value, abnormal_flag.

      date,  labcode, value, abnormal_flag.

      date,  labcode, value, abnormal_flag.

      ...

       

      Lipids

      date,  labcode, value, abnormal_flag.

      date,  labcode, value, abnormal_flag.

      date,  labcode, value, abnormal_flag.

      date,  labcode, value, abnormal_flag.

      ...

       

      .... and so forth

       

      I am not certain whether this requires separate recordsets and multiple tables, templates, or something much simpler and more elegant.  I am always looking for the simplest and most elegant solution.  Not a brute force or "kinda sorta" answer.

       

      thank you