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 sal...