Hi all. I have several tables, Batches, Protocol, Points & Stability. In table Protocol I have a linked field to batch# in Batches, and 2 more fields, a single select; and another multiple linked field from 3rd table Points that makes an array of a variable number of Points (1 month, 3 months, etc.) for a record in Protocol.
My goal is to get any automation if possible, when a new record in Protocol is made (with multiple n points field), to create n new records in the Stability table according the number of points, where each new record pulls the different points of the array and the single select.
This is needed because in Stability table each record uses a initial date field and sums for each Point a fixed months depending on the date (30 days for 1 month, 90 days for 3 months, etc.). So I can get an alert when any record in Stability reaches the due date (initial date + point time).
Any ideas? Tks
Create multiple records from parent table
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.