Hi,
I'm having a bit of difficulty in populating a desired list through the use of a combo box, I'm hoping someone here has he smarts to help me.
We have a training register to show the mandatory training required per position, I would like the user to select the position from the combo box & underneath the mandatory training for that position will appear.
Data is in a table, copied below (I can't upload here for some reason?). So in the combo box I have linked it to a vertical list of the positions, CEO, OPs Mgr etc, I can see them in the combo list. Ideally then if someone could help with a formula to index the position, find all the X's in that column & change the X's to the training in the course name column. I really hope this makes sense but if not please ask away!
So from example below if a user selects Chief Executive Officer in the combo box then underneath the combo box we should see Staff Safety Induction, General Construction Induction & nothing else.
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
I'm having a bit of difficulty in populating a desired list through the use of a combo box, I'm hoping someone here has he smarts to help me.
We have a training register to show the mandatory training required per position, I would like the user to select the position from the combo box & underneath the mandatory training for that position will appear.
Data is in a table, copied below (I can't upload here for some reason?). So in the combo box I have linked it to a vertical list of the positions, CEO, OPs Mgr etc, I can see them in the combo list. Ideally then if someone could help with a formula to index the position, find all the X's in that column & change the X's to the training in the course name column. I really hope this makes sense but if not please ask away!
So from example below if a user selects Chief Executive Officer in the combo box then underneath the combo box we should see Staff Safety Induction, General Construction Induction & nothing else.
| Course Name | Course Code | Chief Executive Officer | Operations Manager | Office Manager |
| Staff Safety Induction | X | X | X | |
| General Construction Induction | CPCCOHS1001A | X | X | |
| Provide first aid | (HLTAID003) | O | ||
| Provide cardiopulmonary resuscitation | (CPR) (HLTAID001) | O |
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
