Meetings Table. Each case has one record in the meetings table. Primary key is meetingnumber. Meetproc Table. Each case has 1 or more records It is FK to the meetings table on meetingnumber. meetingnumber, proceduredescription, procedureCode, procID coProc Table. All the procedures. Primary key is procid Desired Results: ---------------------------------------------------------------------------- DESC JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC ---------------------------------------------------------------------------- lapc 1 0 12 12 0 1 3 2 12 300 12 0 heartb 2 2 0 0 2 1 4 3 10 12 9 2