Tables > Table Relations

Table Relations, RDBMS and Referential Integrity

The corner stone of advanced databases is the normalization and splitting of data into distinct tables to avoid redundancy, and linking it all together via rational relations.
This may be done via the RDBMS applications by Master-Detail designs, by SQL JOIN structures, or it may be specified by the very tables and its associated structure files as Referential Integrity communicated with the application.

Designed as a single datagrid display application, Master-Detail design is beyond the scope of the mainly SQL centered PdxEditor.
However, Paradox Referential Integrity being specified with the tables, PdxEditor may create these relations and will as well reflect established Referential Integrity on a table level.

Unfortunately the BDE Local SQL does not provide a means of creating or modifying Referential Integrity through SQL.