Object and arrays question

[OldManExcellor]

I have products that have properties. (product.name, product.weight, ...)
I have markets that have properties. (market.population, market.inflation, ...)
And then I have product*market combinations that have properties. (product*market.sales, product*market.share, ...)

What is the best way to organize this using objects and arrays?

 

[mikerickson]

The advanced approach would be to use Class modules to create you own custom objects.

 

[OldManExcellor]

That's the route a want to go then.

Do I want to create a product and a market class only, or do I want to create a product*market class as well?

 

[mikerickson]

I'm not sales savy enough to understand what a product*market class might contain.

I would think that if someMarket were a Market object, someMarket.RestrictedToProduct("apple") could also be a Market object.

The restrictedToProduct property could take multiple arguments. Whether that would be an AND or and OR would be up to the designer.

Similarly, every Product object could have a RestrictedToMarket property.