Hi everyone,
Complete newbie here with only a few hours of Access training videos under my belt.
I have one table with three fields: an ID field, day number field (days 1-30 of a course) and a date field which displays the calendar day corresponding to the training day).
I have another table with trainee names and an ID field for each trainee.
For each trainee, I would like to log absence (there are six training sessions per day that each trainee must attend - they attend more regularly than they're absent, so i thought it would make sense to focus on the absences).
I'm trying to get my head around the relationships and setting up other tables - it seems that in whichever way I link my tables, Access doesn't understand what I want!
I'm thinking I need to add the six training sessions as fields in the training days table (or not? somewhere else? a separate table to the training days one?) Then what's the best way to link up the two (or more?) tables then so that I can log each trainee's presence/absence for each of the (30 days * 6 sessions)? Or is it not a question of linking the tables, simply of setting up some sort of query that feeds to a third table? Also, is it possible/advisable to set this up 'behind the scenes' first, then later adding on a user form that does the same?
I've managed to set up one to many relationships nicely in another table (trainee groups) which puts trainees in different training groups, but with all the tables as they are at the moment, my attempts at fiddling with the relationships only result in the trainee IDs matching day IDs (trainee 1 = day 1, trainee 2 = day 2 etc.) - this is obviously not right! What am I missing to be able to log attendance for each of the 180 sessions for each trainee? Once I get that right, I'd also like to view attendance per group (e.g. if a group has 10 trainees, what was their attendance like for the week?)
Any advice would be appreciated - I'm sure for any seasoned Accessor it would be clear where my knowledge gap is - any pointing in the right direction would be really helpful!
Many thanks!