I have a probably very simple problem on a form i have. I have 4 fields: course Id, Week, Student Id and an Attended yes/No tick box.
What i want to be able to do is enter the course Id once and the week number once. Then to put in a students Id and whether they attended then to save this and then put in another student id and whether they attended and so on. This is not a problem but when I look at the data in the attendance table it is only showing the very last student I entered. So basically if I enter 10 students on the form it will only show 1 in the table of stored attendances. can anybody see a better way of doing this??
Thanks

Do you have a form and subform assumming there is a one to many relationship between the course and student tables.

Hi thanks for your reply. Yes there is a one to many relationship and i have a form but no sub form...is this the problem then?