Script to add a record in a different table
Real novice question here, sorry. I want to make a script that will create a new record in a different (related) table, filling in the match field from the original table in the new record. Here's what I want to have happen:
1. From a customer record in the Customers table, click "Add Order" button to run the script. Let's say we're on the Acme customer record, which is customer ID#27.
2. The script then creates a new record in the (related) Orders table and fills in 27 in the customer ID match field, so the order is automatically related to Acme.
I see this done in starter solutions but can't quite backtrack to apply those scripts to my database...