Re:[pilot-db-list] (no subject)

[Chalain Marc<mar...@vo...>]

First please, don't use the upper case it's very hard to read it.
you have different solutions:
 - a field for the date and a boolean field for each student.
   it's good if you often want to see who wasn't present at a date.
 - a string field for the name of the student and few fields for the    date, you can add new date fields after if it's neccessary. You    create a record for each student. (you can add more informations as    notes, options, class...)
   It's good if you often want to watch the work of a particular    student.
 - a string field for the student's name and one for the date. You    create a record for each student who wasn't present at one date.
   I's usefull if you want only check the absents, after you can do a    sorting by date or by student. Now you should write each time the    student's name. (in the next version you could build a students'    list)

I think the best way it's 2 databases: one with all informations for each students + one with the name and the date of the absent student.
Now, i'm working about link between databases then you will be able to replace the name field of the second database to a link to the first one then you couldn't rewrite the student's name at each time. I hope to give a first 0.3.3 beta version in one month or a little more.

Salut,
Marc.
__________________________________________________________
Faites un v=9Cu et puis Voila ! www.voila.fr 
Pendant tout l'=E9t=E9, gagnez une Ford Ka sur Voila Gratter ! http://cybergrattage.voila.fr/voila