Related Query Statements

Child records in related info boxes are synchronized with the current parent record by a query statement that refers to the parent primary key:

SELECT *

FROM <child table> ct

WHERE (:"Parent*<parent primary key>" = ct.<foreign key>

OR (:"Parent*<parent primary key>" IS NULL

AND ct.<foreign key> IS NULL))

In this statement, the "Parent*" keyword represents the parent table. The string that refers to the parent primary key is preceded by a colon and surrounded by double quotes, in the same way as an embedded method call. You can influence data synchronization by editing the query statement:

·	You can synchronize grandchild data and grandparent data without displaying parent data.

·	You can handle NULL values differently.

·	You can synchronize data in two parent tables of the same child table (intersection table) without displaying the intersection table.

·	You can remove some of the child columns by SELECTing only the others.