I wasn't sure what to title this thread, as I'm really not sure how this will work so I hope somebody can help.
Ok, what I have is a training database, with an employees table, and a training items table.
trainingitems table:
- trainingitem_id (PK)
- trainingitem_description
(plus more not relevent here)
employees table:
- emp_id (PK)
- emp_name
- emp_jobroleid (FK - for job roles table)
trainerstable:
- emp_id (FK for employees table)
- trainingitem_id (FK for trainingitems table)
Basically the trainers table is used to link certain employees to certain training items - to show they are authorised to train people on that item.
This all works fine, but there's a catch. We would like to give an option to select "Line Leaders" as authorised trainers and link them to a training item. We have several line leaders and they may leave, or we may promote people to line leader, so the list is constantly changing.
I have a query that filters the employees table for line leaders only.
What I want is to be able to say, for example, training item 5 may be trained by line leaders (and include the record from the line leader query) plus certain selected people - but show them all in the same list.
I hope I explained that well enough, can anyone suggest how this can be done?
Ok, what I have is a training database, with an employees table, and a training items table.
trainingitems table:
- trainingitem_id (PK)
- trainingitem_description
(plus more not relevent here)
employees table:
- emp_id (PK)
- emp_name
- emp_jobroleid (FK - for job roles table)
trainerstable:
- emp_id (FK for employees table)
- trainingitem_id (FK for trainingitems table)
Basically the trainers table is used to link certain employees to certain training items - to show they are authorised to train people on that item.
This all works fine, but there's a catch. We would like to give an option to select "Line Leaders" as authorised trainers and link them to a training item. We have several line leaders and they may leave, or we may promote people to line leader, so the list is constantly changing.
I have a query that filters the employees table for line leaders only.
What I want is to be able to say, for example, training item 5 may be trained by line leaders (and include the record from the line leader query) plus certain selected people - but show them all in the same list.
I hope I explained that well enough, can anyone suggest how this can be done?
