How to Deactivate Links

Hi,
you can do the following:

1. edit SQL query on the Edit SQL query tab. Here is a sample:
   

   select ForeignKey,
   

   
   ForeignKey as DetailLink,
   
   field_1,
   
   field_2,
   
   ...
   
   field_n
   
   from MasterTableName
   
   

2. check off DetailLink on the List page only on the Choose fields tab.
   

   
   

3. set up DetailLink as Custom on the "View as" settings dialog on the Visual Editor tab. Here is a sample code:
   

   global $conn;
   

   
   $str = "select count(*) from DetailTableName where DetailID=".$value;
   
   $rs = db_query($str,$conn);
   
   $data = db_fetch_numarray($rs)
   
   if ($data[0]!=0)
   
   $value = "<A href=\"DetailTableName_list.php?mastertable=MasterTableName&masterkey1=".$value."\">Details</A>";
   
   else
   
   $value = "Details";
   
   

where DetailTableName and MasterTableName are your actual table names, DetailID is your actual field name.

Jane thanks - that worked great!
Wengen