View or Edit linkable fails with SQL error. CustomConnection

Question

Having a lot of trouble getting the view or edit linkable to function. I am using a custom view and the fields are defined as shown in Chono00.jpg.attached.

My HTML custom code is

<tr>
  <td class='njjoCenter'>{mdlListCourseReceipts.accountPaid}</td>
  <td class='njjoCenter njjoborderrightThick'><img src='components/com_u3a/common/img/print.png' /></td>
  <td class='tdidReceipt njjoCenter pad2 njjoborderright' >{mdlListCourseReceipts.idReceipt}</td>
  <td class='tdreceipttype njjoCenter pad2 njjoborderrightThick'>{mdlListCourseReceipts.enmReceiptType}</td>
  <td class='tddatePaid pad2 njjoCenter njjoborderright'>{mdlListCourseReceipts.localDateReceived}</td>
  <td class='tdname pad2 njjoborderrightThick'><?php echo $bookedBy;?></td>
  <td class='tdfeePaid njjoRight pad2 njjoborderright'>${mdlListCourseReceipts.feePaid}</td>
  <td class='tdpaidBy njjoCenter pad2 njjoborderright'><?php echo $paidBy; ?></td>
  <td class='tddatePaid pad2 njjoCenter njjoborderright'>{mdlListCourseReceipts.localDatePaid}</td>
  <td class='tdpayReceivedBy njjoCenter pad2 njjoborderrightThick'>{mdlListCourseReceipts.payReceivedBy}</td>
  <td class='njjoCenter'><img src='components/com_u3a/common/img/edit.png' /></td>
  <td class='njjoCenter'><img src='components/com_u3a/common/img/cancel.jpg' /></td>
</tr>
<tr>
  <?php 
  if (strlen($courseList['short'])>110){
    $scratchString=substr($courseList['short'],0,110).'……';
  } else {
    $scratchString=$courseList['short'];
  }
  ?>
  <td colspan='12' class='njjoTruncateTD' title='<?php echo $courseList['long']; ?>'>Booked for: <span class='njjoclsEmphasizeBox'><?php echo $memberBookedFor;?></span> <?php echo  $scratchString;?></td>
</tr>

My problem is that when i follow that link I get this error

1054 - Unknown column 'mdlListCourseReceipts. IS NULL' in 'where clause' SQL=SELECT `mdlListCourseReceipts`.`idReceipt` AS `mdlListCourseReceipts.idReceipt`, `mdlListCourseReceipts`.`accountPaid` AS `mdlListCourseReceipts.accountPaid`, `mdlListCourseReceipts`.`enmReceiptType` AS `mdlListCourseReceipts.enmReceiptType`, `mdlListCourseReceipts`.`feePaid` AS `mdlListCourseReceipts.feePaid`, `mdlListCourseReceipts`.`bookedBy` AS `mdlListCourseReceipts.bookedBy`, `mdlListCourseReceipts`.`paidBy` AS `mdlListCourseReceipts.paidBy`, `mdlListCourseReceipts`.`datePaid` AS `mdlListCourseReceipts.datePaid`, `mdlListCourseReceipts`.`dateReceived` AS `mdlListCourseReceipts.dateReceived`, `mdlListCourseReceipts`.`payReceivedBy` AS `mdlListCourseReceipts.payReceivedBy`, `mdlListCourseReceipts`.`localDatePaid` AS `mdlListCourseReceipts.localDatePaid`, `mdlListCourseReceipts`.`localDateReceived` AS `mdlListCourseReceipts.localDateReceived`, `mdlListCourseReceipts`.`pickDatePaid` AS `mdlListCourseReceipts.pickDatePaid`, `mdlListCourseReceipts`.`pickDateReceived` AS `mdlListCourseReceipts.pickDateReceived` FROM `hvu3a_u3a_vuCC_lisCourseReceipts` AS `mdlListCourseReceipts` WHERE `mdlListCourseReceipts`.` IS NULL

Just plain stuck! I could switch to a table option and see if that fixes it but that won;t really work as I need to access other related tables. I could no doubt get round it by writing my own links but that seems to be missing the value of CCC5

Any suggestions? I must be missing something.

Regards
Nick

Forums

View or Edit linkable fails with SQL error. CustomConnection