I have a "health and safety" part to my database. On this a user can select the type of works they are doing in a LIST BOX and it will populate a report with the appropriate control measures for the risks.
There will be some overlap with the control measures so I'm thinking how to avoid this.
E.G. user will be working with ladders and mobile platforms. Both of these will need working at height control measures and I don't want to repeat information.
So I would like to have some things not visible in the listbox (working at height) but I want I want it to be selected when a relevant task is selected. That way I can have specific details for ladders/platforms then the general working at heights also.
I guess I would implement the code to select associated tasks on the click event which generates the report? or the double click event in the listbox? (which selects it).
What would this code look like? I don't need the code just cant visualise how to achieve this.
Thanks, Andy.