Automate record creation when new record is found in ESS table
I have a few ESS table in my design but the only two fields that I can create are summary and calculation fields.
There are many other field that I want to create but unfortunately I cannot. I tried having a related table with the "allow modification from related table" feature on but unfortunately I need to type something in a portal for it to generate a record with the associated ID. If I am going with the related table route, Is there a way to auto create a record in the related table as soon as it is in the ESS table.
I am also open to suggestion, most of the other fields that I will be adding are _pk, _fk, date and some other text field
A script could loop through the records in the ESS record and create matching records in the related FileMaker table. Or it could do this for one or a few records in that table "on demand"--such as after pulling them up in a found set on a layout.