Foxpro CrossTab Question (VFP 8.0)

[njpilot172]

I am trying to create a simple attendance form using VFP 8.0.

My users are currently traking attendance in Excel.
They want a similar interface to what they're currently using: Student name in the 1st row, and logical fields for every day that the class is in session flowing horizontally to the right.

An array would be perfect for this task as the number of students and days are both variable. The problem, however, is displaying the array in a format that is user-updatable. A grid would be perfect but grids do not support array data.

Any ideas???

Todd

 

[njpilot172]

I've decided to create a cursor with the same number of columns as the array then append them in. As for saving the data, I'll probably end up scaning thru the columns and drop the data into a table (Class, Name, Date, lAttended) for each day attended.

My FoxPro motto is "There's more than one way to skin a Fox" (You can quote me on that). I'm open to any and all suggestions.

TIA!!!

Todd