Datamodel problem

[avastani]

Hi

I am having trouble in my datamodel, where I would like to ultimately pick a Division and find its associated ProductGroupName(s) but given the datamodel, I am not able to achieve that. Although my Sales table has information to link ProductGroupName and Geography for Division information, it does not connect properly. Any suggestions?

[#2]

Hi Amir,

The data model looks ok to me. Suggest you to check the data once, there might be Division(s) for which there are no ProductGroupName(s).

Thanks

Amit