I have a DB for recording safety information. I have a form to document individual accidents. Each accident can cause multiple types of harm to multiple assets. In the accident form, I have a combobox where I can select a single asset and another where I can select its associated types of harm. Once I make these two selections, I would like a button to create a new record made up of the selected asset and its associated types of harm. I would like to be able to go through this process a number of times (selecting one assets and multiple harm types) until I have identified all of the types of assets the accident can harm including the different relevant type of harm. I am not sure the best way to organize tables to do this and I do not know how to write the VB code for the button that adds a new asset with its harm types. Note that different assets have different numbers of harm types. I am totally new to VB and access and this is the hardest thing I have tried to do (as well as likely to be the hardest thing I need to do). This is going into a book on safety (DB on CD) and I would be happy to acknowledge in the book the person who helps me solve this problem.

Software/Hardware used:
MS Access 2007