2 parent tables
I have a Calc table, child of a Patient table. However, there are certain 'settings' that affect Calc that can change during the life of a Patient and that would affect >1 Patient. These I've grouped in a Config (configuration) table.
So Patient < Calc & Config < Calc are both 1 to many relationships. But Patient and Config are neither parent or child to each other. Obviously if I record a new Patient or Config record, there needs to be a new Calc record. Calc is displayed in a portal on the Patient layout.
Q: How do I ensure that Patient and Config are synchronised within a Calc record?