Example: Grandchild Data Synchronization

Suppose you want to display a list of Participants for each Scheduled Tour, without displaying Reservations. You need to turn parent-child synchronization into grandparent-grandchild synchronization.

The default related query statement of the "Participants taking part in this Reservation" related info box is:

SELECT   *

FROM     PARTICIPANT p

WHERE    :"Parent*RES_ID" = p.RES_ID

OR     

(        :"Parent*RES_ID" IS NULL

   AND   p.RES_ID IS NULL

)

To get grandchild synchronization between Participants and Scheduled Tours, make a subclass of this related info box, rename it to "Participants taking part in this Scheduled Tour", and change the main query to:

SELECT   p.*

FROM     PARTICIPANT p, RESERVATION r

WHERE    

(        :"Parent*SCHEDTOUR_ID" = r.SCHEDTOUR_ID

   AND   r.RES_ID = p.RES_ID

)

OR 

(        :"Parent*SCHEDTOUR_ID" IS NULL

   AND   p.RES_ID IS NULL

)