Hi,
The title seems vague, but i could not think of anything more descriptive. I am creating a database and i am a bit stuck. I have started to create a database for pupils in a school.
I have created the tables, includes:
Pupil (containing pupil information, class etc)
Homework (containing homework information)
Complete (table linking the above, and a check box to determine if a pupil has completed a homework or not)
The problem i have is that when i enter the details for the homework, i dont know how to force this information into the pupils data. Basically, i want to enter the homework data, then perform an action that automatically assigns this homework to the pupils records, instead of me doing it one by one for each pupil on the main form (main form has pupil information and a sub form that has the tblcomplete date with the check box).
Any help would be appreciated. Thanks in Advance
Ish