2 Replies Latest reply: May 16, 2012 4:07 PM by perry van der meijden RSS

    linking tables

    perry van der meijden

      Hi,

       

      I have the following tables from a questionaire

       

      table1

      key     person      organisation     mail     Q1     Q2     Q3     Q4     Q5     Q6

      01       xxx          xxxxx              xxx      0       1       2          1       2       1

      02       xxx          xxxxx              xxx      1       2       1          3       2       1

      03       xxx          xxxxx              xxx      1       0       3          1       0       0   etc

       

      table2

      keyquestion     subject                    question

      Q1                  finance                     how .....?

      Q2                  finance                     how .....?

      Q3                  Human Resource      how .....?

      Q4                  Human Resource      how .....?

      Q5                  Service                     how .....?

      Q6                  service                     how .....? etc

       

      table3

      answer           teXt

      0                   bad

      1                   average

      2                   good

      3                   perfect

       

      Does anyone have an idea how to:

      * connect the answers in table1 below Q1, Q2 etc to table3?

      * connect the titles in table1 to table2?

       

      I would like to make some graphs (for example) with a histogram of the scores for a single organisation and a specific subject. Anyone an idea? I can't find a similar question at this forum.

       

      thanks in advance