Need help creating a data model!

Hi, cdawidow 

Generally, we don't recommend relating two fact-type tables directly using many-to-many cardinality. Instead of relating fact-type tables directly, we recommend you adopt Star Schema design principles. You do it by adding dimension-type tables. The dimension-type tables then relate to the fact-type tables by using one-to-many relationships. This design approach is robust as it delivers flexible reporting options. It lets you filter or group using any of the dimension-type columns, and summarize any related fact-type table. You may create a model like below.

About many-to-many relationship guidance, I'd like to suggest you refer to the document  .

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.