AnsweredAssumed Answered

2 parent tables

Question asked by tays01s on Jan 13, 2015
Latest reply on Jan 18, 2015 by tays01s


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?