How should I structure a sheet to compare potential combinations of entries between three tables

So, I need to figure out the best way to structure a sheet to compare guns in a video game for an online community. Here is an example of an end goal:

You can pick up weapons in the open world in this game. Every gun that you find randomly “rolls” with two traits; one in “slot 1” one in “slot 2”. The traits available are specific to one slot or another; i.e. trait A can only appear on slot 1 and trait Z can only appear on slot 2. But most importantly, not every trait is available on every weapon.

I currently have one table with a list of all weapons, one table with a list of all available slot 1 traits, and a third table with a list of all available slot 2 traits.

I have two questions on how y’all think I should proceed:

1) How would you suggest that I designate which traits are available on each weapon?

2) Once available traits are assigned to each weapon, I want to create one input for each slot (presumably multiple selection dropdowns) that can determine something something along the lines of “What weapons exist that can can be found with trait A, B, or C in slot 1 and also can have traits X, Y, or Z in slot 2.

To clarify, I want an output of every weapon that has any (not all) of the following trait combinations: AX, AY, AZ, BX, BY, BZ, CX, CY, CZ. I feel like this could be accomplished rather easily, but trying to figure out how to structure it best is giving me a headache.