Update child foreign keys when updating parent primary key
I've tried searching but I didn't find an answer.
I have a master table with 3 related child tables.
If I update the master primary key I end up losing the connection with its child tables.
How do I make FileMaker to update foreign keys on child tables when I update the primary key on the master?
Thanks in advance,