[AccessD] Table Structure questions

Hello All,

I have been asked to set up a call monitoring db for several different 
groups.  A few pieces of data will be captured for each call and then 25 
questions will be answered for each call.  Each group may or may not have 
the same 25 questions...which they can add or remove throughout the month.  
Initially I wanted 2 main tables for data collection(1 for call info and 1 
for Answers)...The Answers table would have 1 row per question(instead of a 
column for each)...so 25 records per call monitored.  I thought this would 
be best so as new questions were added and discontinued...there would be no 
need to change the forms,tables, or reports...but with this method I will be 
over 1 million records in 6 months.  I've informed them they will need some 
BE other than access for this scenario.

The question I have...is there a more efficient way to store this type of 
data?(Also, the answers are all 1,2,or 0...so its very little info...just a 
lot of rows)

Thanks,

Mark

_________________________________________________________________
Stay informed on Election 2004 and the race to Super Tuesday. 
http://special.msn.com/msn/election2004.armx