Thank you for your post.
Since each piece of equipment can be used by different team members, and since each team member can be trained on several pieces of equipment, this creates a many-to-many relationship. Therefore, create a third table that joins the different team members to the different types of equipment. You may have something like the following:
In JOIN TABLE, you can enter a team member (through Team_ID), the piece of equipment (through Equipment_ID), and an optional "Date" for when the team member was trained. At any time, you can see what people were trained on a specific type of equipment, and you can see what equipment was used by team members.
If you need clarification for any of the above steps, please let me know.