Help with a solution to create a record when another record (different table) is made
I need help finding a solution that allows my database to automatically create records in a sub/related table when a record in the main table is made.
Basically for every record I have in the main table, I want the same number of records made in the sub table.
Can anyone help me out?
#Create Record in Main table
Set Variable [$ID ; value: MainTable::PrimaryKeyField ]
#Create related record
Go to Layout ["RelatedTable" (RelatedTable)]
Set field [RelatedTable::ForeignKey ; $ID]
Go to Layout [Original Layout]