Referential Integrity
You can use the attributes listed in the following table to implement referential integrity at runtime.
Attribute | Description |
---|---|
PXParent | Creates a reference to a parent data record. By default, when the parent data record is deleted, all child data records that reference it are also deleted. (You can change this behavior by using the LeaveChildren property.) |
PXDBChildIdentity | Indicates that a DAC field references an auto-generated key field from another table, and ensures that the field value is correct after changes have been committed to the database. |
PXLineNbr | Generates unique line numbers that identify child data records in the parent-child relationship. |
Note that all the attributes in the table above add server-side logic used at runtime. The referential integrity is implemented on the server side.