2. PHPRunner General questions
  3. [SOLVED]  Cascading Referential Integrity
This topic is locked
[SOLVED]

 Cascading Referential Integrity

 		9/5/2019 4:11:19 PM
PHPRunner General questions
U
 united001 author

From what I can understand, PHPRunner does not support cascading referential integrity, as does Microsoft Access? Or does PHP runner do it in a different way that I have been unaware?
By cascading referential integrity I mean that if two database tables are related by their primary keys being the same (also call primary and foreign keys) that if a field in the master table is changed, that the same field in the second or child table is also changed (updated).
Randy J
Sergey Kornilov admin 9/5/2019

There is no such built-in feature but you can implement it manually using events like BeforeEdit.
M
 		MikeT 9/29/2019

This is something the database engine should do. In MySQL for example lookup ON CASCADE UPDATE in the mysql documentation.