This topic is locked

Mouseover Lookup

3/14/2008 5:58:12 AM
PHPRunner General questions
jpedwardspost author

Hi,
I would like to know if there is a method for creating a lookup mouseover popup of detail items when the user hovers over a field in list view.
I have a table in list view and one of the displayed fields is a foreign_key field to another table. When the user hovers over this foreign key field I would like a popup to appear with certain data items (agent_tel, agent_mob) displayed.
I have already configured the foreign key field using the lookup wizard and it displays the agent_name. I know I can use a concat(agent_name, agent_tel, agent_mob) sql statement in the lookup wizard and the agent_tel and agent_mob would permanently display on the list view but I would much rather they just appear as a popup when the user hovers over the agent_name.
Anyone know how to do this? Any help much appreciated.
JP.

J
Jane 3/14/2008

Hi,
you can do the following:

  1. set up master-detail relationships between main and lookup table on the Datasource tables tab,
  2. use code of detail link as sample on the Visual Editor tab:
    {if $useAJAX} onmouseover="RollDetailsLink.showPopup(this,'DetailTableName_detailspreview.php'+this.href.substr(this.href.indexOf('?')));" onmouseout="RollDetailsLink.hidePopup();" {/if}