Populate ID field in multiple related tables
I am new to FM and my primary background is SQL server. I am creating a database and have a quesiton. In SQL there are processes called triggers that can run on a record create/update/delete to populate data in related tables. I cannot seem to find this in FM Pro. I have 2 tables:
I have built a relationship between the 2 tables on recID. What I need is for a record to be created in table 2 with just the recID field populated everytime a new record is created in table 1. So table 1 will be completely filled out and table 2 will have a row for each recID that can be filled out later. Has anyone done this before?