structure

[andy49]

Id like to create a database of who attends my revision sessions (which are very frequent)



Idea is that I'd be able to select who's there very quickly and this would then update the database automatically that they turned up recording date and time.

Suggestions?

Table1

Pupils names etc including which class they are in

Table 2

Revisiondate and revisiontime fields

[ranman256]

tRevisions table (table2)
----------------
RevID (auto)
RevDate (date/time, one field holds both date and time)
PupilID (long)
etc..

the tRevison table will hold all attendees and the date.
make a parent/child form, pupil is the parent form showing all details of the pupil.
the child form is the Revisons. Link the sub form to the parent form on LINK CHILD FIELD, and LINK PARENT FIELD (both set to PupliID)
then you can view a pupil and all his revisions on the one screen.

[pbaldy]

This might help:

http://www.baldyweb.com/MultiselectAppend.htm

[andy49]

Great advice guys

Really helped