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.
[TABLE="width: 497"]
<colgroup><col><col><col span="3"></colgroup><tbody>[TR]
[TD]Course Name
[/TD]
[TD]Course Code [/TD]
[TD]Chief Executive Officer[/TD]
[TD]Operations Manager[/TD]
[TD]Office Manager[/TD]
[/TR]
[TR]
[TD]Staff Safety Induction[/TD]
[TD] [/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]General Construction Induction[/TD]
[TD]CPCCOHS1001A[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Provide first aid[/TD]
[TD](HLTAID003)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]O[/TD]
[/TR]
[TR]
[TD]Provide cardiopulmonary resuscitation[/TD]
[TD](CPR) (HLTAID001)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]O[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 497"]
<colgroup><col><col><col span="3"></colgroup><tbody>[TR]
[TD]Course Name
[/TD]
[TD]Course Code [/TD]
[TD]Chief Executive Officer[/TD]
[TD]Operations Manager[/TD]
[TD]Office Manager[/TD]
[/TR]
[TR]
[TD]Staff Safety Induction[/TD]
[TD] [/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]General Construction Induction[/TD]
[TD]CPCCOHS1001A[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Provide first aid[/TD]
[TD](HLTAID003)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]O[/TD]
[/TR]
[TR]
[TD]Provide cardiopulmonary resuscitation[/TD]
[TD](CPR) (HLTAID001)[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]O[/TD]
[/TR]
</tbody>[/TABLE]