I have a product table:
ID Desc No. of lines old/new 1 prod1 5 old 2 prod2 4 old
I have 10 rows in product table.
i want to grow the product table eg - to 25 new rows = so that means its a 250% increase in product range.
but the new lines added (rows 11 to 35) will be copies of the original 10. there will be duplicates. thats fine, but its the
no of lines which is the concern.
for example lets say the original 10 rows had a sum of 50. if i copy over randomly and get to 35 rows, ive increase the lines by 250% but the total sum on lines most likely will be over 350%. i want the sum of lines to increase exactly by 250%, so total will be 125. i dont want to update the original 10 rows, ive tried to update new products by minusing 1 from no of lines to bring the increased percentage down but its a long process and temperamental.