Unanswered: Allocated Product Demand over several models
I am having trouble with this finding a way to divide demand for a product equally over the model offering. My issue is that I get data set from one department that lists the Product Name Number and Model Number i.e.:
Pro# ModelNum Name Demand
1234 1234.001 Name 1.0 ?
1234 1234.002 Name 1.1 ?
1234 1234.003 Name 1.2 ?
4567 4567.001 Name 2.0 ?
4567 4567.001 Name 2.1 ?
In a separate file I receive total demand by Product Number i.e.:
What I want to do is run a update query that take the demand report and updates the demand in the database by Model (i.e. divde demand for Product by number of model).