One to many relationships and forms


#1

I have 2 tables a sales order table and a sales order item table, to allow a sales team member to raise an order with multiple products on one order.

I would like the team member to do this via a form.

How do you auto-generate a new record in the sales order table from a form in the sales order item table?