Hello, community!

May be you can help to resolve my task.

We have a 2 simple tables:

1. Clients. (with Form1 for new clients)


2. Orders
   
   – with ClientID linked field.
   
   – with Package (regular/premium single select)

Now our new clients are filling the Form1 and after that we are creating manually a new Order in Orders table with this client.

I want clients to fill out Form1, select a Package type and create a record in both the Clients table and the Orders Table.

How to do it? Need to use third-party add-ons like miniextensions or something else?