0

Automated creation of a record in subtable

Hi all,

 

I hope you're doing well. I have a master table and a subtable - each time I create a record in the master table, I want a record to be created in the subtable and connected to the main table via a table reference.

 

I'm thinking this might be possible using the global "trigger on create" field on the master table, but not so sure how - could you point me in the right direction?

 

Many thanks,

Giovanni

2 replies

null
    • blackie
    • 3 yrs ago
    • Reported - view

    try something like this

     

    let Main := this;
    let CR := (create Table_Name);
    CR.(Link_field := Main);

     

    Table_Name is the table you want to create the record in

    Link_field is the pointer back the main table

    • Giovanni_Zagarella
    • 3 yrs ago
    • Reported - view

    Hi Blackie,

     

    Thanks a lot, this solution works perfectly!

Login to reply

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 324Views