Help linking Order Items to newly created Orders in Knack

Ask the Community Get Answers
1

Hi everyone,

I’m working on a Knack app with the following tables:

  • Accounts

  • Products

  • Orders

  • Order Items

The current setup is as follows:

  • Logged-in customers can go to the Products tab, which shows a search view of all products.

  • I’ve added an action column that lets users add products to their basket.

  • The Basket view displays all the Order Items, and when the user hits Submit (via a form), a new Order is generated.

I’m struggling with the next step of how to automatically move the existing Order Items and link them to the newly created Order record when it’s generated.

Has anyone built a similar setup or could share advice on how to achieve this?

Thanks in advance!