You can add images to the
record selector buttons that will display if the query conditions
for an Extra Query are met.
To add an image to a
spreadsheet's record selector buttons:
||Make sure you have selected the appropriate Info Window object.
This should already be in spreadsheet look.
||Open the Property Inspector.
||Use the Object tree to select the parent window of the Info
||From the menu bar, choose Insert, Extra Query.
A dummy Extra Query and its
resulting field are inserted.
||From the menu bar, choose Design, Extra Query, and then choose
the inserted extra query.
You can also use the Object
tree to select the Extra Query column. Either way, do NOT specify
the underlying query by selecting the dummy field and setting its
Values property. This does not produce the desired result.
||In the Property Inspector, select the SQL Statement property on
the General tab page and press the edit (...) button.
The SQL Definer opens,
enabling you to specify the query.
||Add an Extra query, suing the following syntax:
SELECT '<icon name>' "GRID_IMAGE" FROM
<table> WHERE <col> = <value>
||Save your changes. For each record that matches the condition
above the icon "<icon name>" will be displayed on the record