You need to configure the database to have a one-to-many relationship between ACME_ORDER and ACME_ORDER_ITEM.

Add a new field “ORDER_ID” on the ACME_ORDER_ITEM table and set the field as a foreign key to the ACME_ORDER entry.

Add a new field “ORDER_ITEM_ID” on the ACME_ORDER table and set the field as a foreign key of the ACME_ORDER_ITEM entry.

Add a new field “ORDER ITEM_ID” on the ACME_ORDER table and set the field as a second primary key of the ACME_ORDER_ITEM entry.