I have a huge amout of data. 14 * 3 pieces of attendance information for
3000 students for 180 days. For each day, Each student contains 14
pieces of data that each contain 3 fields. I will be adding 4 quarter
grades to the Student record later. We are trying to coorelate
attendance and tardies to class grades. InfoSys says it is not possible.
Balderdash...

Can the BEGIN RECORD ... END RECORD  and the multi-dimension arrays
architecture of FB handle this kind of structured set of data?  

Here are my thoughts:

BEGIN RECORD StudentDay
  DIM 8 PermNumArray$(14) 'eight digit ID number   80125468
  DIM 8 DateArray$(14)    'eight digit date  12252006
  DIM 1 AttCodeArray$(14) 'one character attendance code   T
END RECORD

BEGIN RECORD Student
  DIM 2 QtrGrade$(4)     'two character grade    A+
  DIM YearArray(180) as StudentDay
END RECORD

DIM School(3000) as Student

'do I have to unpack one level at a time to get down to a single date
code?
'Or can I directly access the deepest piece of date directly using
multiple indices?

'Student #124 Grade #2
Grade$ = School.QtrGrade$[1](123)

' I am unclear as to the type of enclosure when going three deep.
' I want to see Student #124 Day #76 AttCode#4
Code$ = School.YearArray.AttCodeArray$ [3][75](123)