Need Db to track attendance

[manpaul]

I was trying to create a table for attendance 366 days and I wanted to have a logicalfor eaqch day and hit the limit of 255 does anyone have any ideas to have a table with the required 366 day fields that I need

Paul

 

[Mike Lewis]

Paul,

Sounds like you need a separate child table. This would have one record for each attendance for each day, with a foreign key back to the parent table. The child table would have a single logical field to indicate whether that day's attendance is true or false.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[mkrausnick]

Or 12 records (one per month) each with 31 fields.

Mike Krausnick
Dublin, California

 

[manpaul]

Thanks for the comments, all good, but here is what I need to track and I want the best way possible. It is for a daycare and all they have to track is that the child was there. Do not need hours or in and out times, just was the child there that day, basic attendance.

Thanks Paul

 

[TamarGranor]

Just adding my voice that you want to track attendance in a separate table with one record per person per day, even if the only data field there is a logical. Eventually, they'll want to do things like count the number of days absent. Doing that with a ton of logical fields is a real PITA.

Tamar

 

[Mike Lewis]

Paul,

I'd go for a table containing the child's ID, the date and the logical flag to say if the child was present. It's up to you whether the child's ID is, say, the child's name, or an integer that links back to the child's record in a parent table.

Even if you never add any other fields, that will be a better model than putting 366 fields in one table.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[manpaul]

Thanks every one and I think that I will go with the one table with the child number prorgam/class date an a attendance logical flag. What I am thinking of doing is loading all the students into the table for the date even if they were not there, that way I can pull out the info a determind weather they were there that day or not from the one table?

Paul

 

[baltman]

Or a char field for each month with a width equal to the number of days in the month and have the char position represent day. Populate with '1' or '0' or 't' or 'f'?