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 action statement. 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.