Thanks for the replies.
I think a picture paints a thousand words, hope this works. please see attached.
Disregard 1Qty & 1UoM, 2Qty & 2UoM fields in the product Table, as you can see I'm playing with a many to many relationship as a conversion table. lol next post.