Re: How to insert multiple records against single order id/ primary key

[Peter Brawley]

You need an order_items table with its own PK in which each row carries an order_id FK reference to the orders table and an item_id FK reference to the inventory table.

See examples in https://www.artfulsoftware.com/dbdesignbasics.html