Hello

I have yet another database design questions, that I hope you will
help me with. How would I implement an order consisting of a number of
order lines in a database.
Here is my best shot.

Order table
OrderID (PK)
Date, Soldby etc.

OrderLines tabel
OrderID (FK) (PK, part 1 of 2)
LineNumber (PK, part 2 of 2)
Quantity, etc.

Is that a good design or is there a better design?