Hey All,
I am trying to create a QVD for both Products and Companies. See attached for my best attempt at a cropped screenshot in Windows XP (LOL its been a while).
I started with one row for each company and on that same all of the core products associated with the company, separated by commas. So I used subfield and separated them out (second attachment).
I have been messing around with creating keys, as can be seen in the first attachment, but I can't get it right. My last attempt was the closest, as the 'Core Products' table looks good but the 'Products' table has a messed up granularity.
Can anyone help with some advice??