Extra Query Example 2: Child Box Background Color Dependent on Parent Data
The Reservations info window by default contains a Participants detail box because reservations cannot exist without participants. Suppose you want participant records grayed out if a reservation is canceled. You will have to define an action to make this happen, and a search specification to refer to the control you want the action to operate on.
To gray out participant records when reservation is canceled:
Make sure you select the Info Window itself and not one of its components. The status line should read Info Window: Reservations.
A query object and a visible extra query control are created.
SELECT 'x' FROM RESERVATION
WHERE CANCEL_DATE IS NOT NULL