Griffin1985
New member
- Local time
- Today, 00:49
- Joined
- Apr 7, 2017
- Messages
- 4
Im looking for a point in the right direction on how about to do the following.
I have the following tables
Staff members(a table of staff memebers)
Training(a table of of trainings)
with the training, i would like to have it return what staff were current(staff have a status field) at the time of the training, and then select whether or not they attended the training.
Im just a bit confused about the best way to go about this, im playing around with a many to many relationship subform but im not getting what i really want.
Please bear in mind ive been teaching myself over the last couple of months in my spare time so Im quite the noob.
if you need anymore details or examples to clarify what im talking about please let me know
Thanks
I have the following tables
Staff members(a table of staff memebers)
Training(a table of of trainings)
with the training, i would like to have it return what staff were current(staff have a status field) at the time of the training, and then select whether or not they attended the training.
Im just a bit confused about the best way to go about this, im playing around with a many to many relationship subform but im not getting what i really want.
Please bear in mind ive been teaching myself over the last couple of months in my spare time so Im quite the noob.
if you need anymore details or examples to clarify what im talking about please let me know
Thanks