multiple many-to-many relationships

[FMAlanbrooke]

Hi, I'm designing a database to keep track of various things in the design for a simulation board game. The game has six scenarios and over 40 variants. Each game can choose one scenario and each scenario can choose one variant, but not all variants are possible in all scenarios. Each game can have many pieces/counters. but not every piece can be used in every scenario or variant. So I want to be able to record which of 200+ pieces/counters can be used in which combination of scenarios and variants. Does a design like this allow for these things to be recorded?

[ItsMe]

I usually test my table designs with query objects. I will create SELECT queries to append records to my tables, Once I have sample data, I will create additional queries to further test the table structure. I usually go back and forth between table design and using queries to test the design. Once I have a table design that functions with the queries, I will move to making a few basic forms.