Re: Design question from newbie

2001-09-04 Thread Adams, Bill TQO
Andrew Ward wrote: > As I said, not all organisations were asked the same questions so I can't > just put the data in directly > > The only way I can see of dealing with this is to create tables like > ID,QUESTION,RESPONSE > 1,"YEAR",2001 > 1,"SEX",1 > > This doesn't strik

Re: Design question from newbie

2001-09-04 Thread Carl Troein
Andrew Ward writes: > The only way I can see of dealing with this is to create tables like > ID,QUESTION,RESPONSE > 1,"YEAR",2001 > 1,"SEX",1 > 1,"AGE",3 > 1,"RATING A", 7 > 1,"RATING B", 6 > ... > > This doesn't strike me as very smart. I would greatly