Hi,
I created a table of stock codes each with multiple subcomponents, each subcomponent (1 to 20) as different new field:
Field 1: Stock_Code
Field 2: Sub1
Field 3: Sub2
Field 4: Sub3
Field 5: Sub4
etc.
As far as I've picked up this table isn't normalised.
I would like to create a second...