Master Detail relationship

Hi,
you can do the following:

• edit link to detail table on the Visual Editor tab --> HTML mode.
  
  Here is a sample (my changes in Bold):
  

  {if $row.1detailsfound_value}<A href="DetailTableName_list.php?{$row.1DetailTableName_masterkeys}"
  

  
  {if $useAJAX} onmouseover="RollDetailsLink.showPopup(this,'DetailTableName_detailspreview.php'+this.href.substr(this.href.indexOf('?')));" onmouseout="RollDetailsLink.hidePopup();" {/if}>DetailTableName</A>{/if}

• then add following code to the List page: After record processed event on the Events tab:
  

  global $conn;
  

  
  $str = "select * from DetailTableName where DetailID=".$data["MasterID"];
  
  $rs = db_query($str,$conn);
  
  if ($data = db_fetch_array($rs))
  
  {
  
  $row["1detailsfound_value"]=true;
  
  }
  
  else
  
  {
  
  $row["1detailsfound_value"]=false;
  
  }

Hi Jane,
Thanks for your reply - it's great to know it can be done, although I'ver not quite managed it yet. Will play around and post again with more details if I'm still struggling. I would also be interested to know if it is possible to have links to the 'detail' information from the view page or if there is a way to add the information in a text box?
Thanks again
DKWID

Hi
I may be wrong but I think the problem lies in the way I have set up the tables. I think the below is correct?

global $conn;

But I get an error description > Unknown column 'spa' in 'where clause'

When I try using accommodation name which is both the primary and foreign key (which I though might fix the problem) I get the following error!
I get an error > You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'name=Elephant House' at line 1

Any ides? Thanks in advance

I've found its better to put quotes around the value. See http://www.asprunner.com/forums/index.php?...ost&p=24118

Hi,

I test this example - this is good thing. How about too many details pages? How I can change this script:
global $conn;

$str = "select from DetailTableName where DetailID=".$data["MasterID"];

$rs = db_query($str,$conn);

if ($data = db_fetch_array($rs))

{

$row["1detailsfound_value"]=true;

}

else

{

$row["1detailsfound_value"]=false;

}*
Rimantas

Thanks

Rimantas,
repeat all actions for each detail links.

I have tried the above code and it works great. One more question about the preview: Is it possible to select only a few fields from the detail table to display in onmouseover preview, and when you click the link, you will still see the complete detail list page? The reason is you may have e.g. ten fields in your detail table and you list them all. But for master-detail relation preview, only a few fields, e.g. three, are important.

Hi,
you can do the following:

1. create custom view of detail table on the Datasource tables tab, setup master-detail relationships for this view also, check three fields on the list page for this view on the Choose fields tab.
   
2. then edit detail link on the Visual Editor tab.
   
   See my changes in Bold:
   

   <A class=tablelinks2 href="DetailTable_list.php?{$row.1DetailTable_masterkeys}" {if $useAJAX} onmouseover="RollDetailsLink.showPopup(this,'DetailTableView_detailspreview.php'+this.href.substr(this.href.indexOf('?')));" onmouseout="RollDetailsLink.hidePopup();" {/if}>DetailTable</A>
   

And remove column of links to DetailTableView on the Visual Editor tab.

Hi,

1. create custom view of detail table on the Datasource tables tab, setup master-detail relationships for this view also, check three fields on the list page for this view on the Choose fields tab.
   
2. then edit detail link on the Visual Editor tab.
   
   See my changes in Bold:
   And remove column of links to DetailTableView on the Visual Editor tab.
   

Jane, your code worked perfectly. Thanks a lot.