How to link a product to the profile of another one?

I’m stuck with list/relation/Id row
My users can create at team of ‘warriors’. Every warriors have different profiles. My users have to select a weapon, inside a list (table:weapon), for one of his warrior.
I can make a relation between the user and the weapon but that’s not what I want…
I want to see on the profile of the warrior the weapons that he selected and I want to see inside the list of weapons which warrior has which weapons. (1 warrior can have many weapons and 1 weapon can have many warrior). I have to make a link between the profile of the warrior (table:warrior) and the weapons(table:weapon). This is where I get stuck!