I’m creating a database of training staff have completed. I want to be able to cross reference between a table of staff and a table of training so I can:
pull up a staff member’s records to see what training they’ve carried out
see the different training that has been carried out and expiry dates of those
So I can store the data, I’ve currently got it set as one table that does everything but when I add new training for a member of staff, I need to copy their data (team etc) for that new training. Or when I create a new training for lots of people, I’m having to copy the course details for everyone (course name, date etc).
Complications are that there will be courses that staff will complete on different days but it would be good to view them in the training table all together.
I can’t visualise how the two will work together or how to set it up. Can anyone make any suggestions or send a snapshot of something similar you’ve created? I have a feeling it may be something to do with Lookup but I haven't used this before and I'm not sure how it works.