I have a products table with raw material proportions. 2nd table with raw material rates.
<tbody>
Product name
RM names
%age
Product1
RM2
49%
Product1
RM3
51%
Product2
RM1
30%
Product2
RM3
50%
Product2
RM2
20%
</tbody>
<tbody>
Date
RM names
Rate
01-04-2017
RM1
100
01-04-2017...