AnsweredAssumed Answered

Script to add a record in a different table

Question asked by Fryx on Oct 26, 2012
Latest reply on Dec 20, 2012 by philmodjunk


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