I have one table that’s a list of PURCHASES. Each purchase can be one of multiple colors, has a quantity, and is going to one of multiple LOCATIONS - so it’s many-to-many, each color can go to many locations and each location can have many colors.
On...