> I'd use
>
> Order table
> OrderID (PK)
> Date, Soldby etc.
>
> OrderLines tabel
> OrderLineID (PK)
> OrderID (FK) (index, part 1 of 2)
> LineNumber (index, part 2 of 2)
> Quantity, etc.

Thank you very much, it helped a lot.