Please help me, i have been struggling for hours today.... I didnt have this problem before and now have changed something not sure what!
When I view my site i can see the master table populate but nothing comes up on the child table please help.... i have security table did every thing even given all users all view access... but still nothing!
there is my script found in templates/clientIndex_list.htm (clientindex is my master table)
please help this is seriously urgent and my boss is on my head as i made him buy 2 licences of this software....!!!
<html {$html_attrs}>
<head>
<title>Client Demographics</title>
<link REL="stylesheet" href="include/style.css" type="text/css">
<!--[if IE]>
<link REL="stylesheet" href="include/styleIE.css" type="text/css">
<![endif]-->
{BEGIN style_block}
<style>
height100{$id} {padding:10px;}
mastertable_block{$id} {margin-left:50px;margin-top:10px}
search_records_block{$id}
{
vertical-align:middle;
text-align: right;
padding: 9px;
display: table;
width: 99%;
{BEGIN RTL_block}
margin-top:27px;
{END RTL_block}
}
search_records_block{$id} > * {vertical-align:middle;}
toplinks_block{$id} {padding:10px; margin-bottom:3px;}
login_block_right{$id} {text-align:right;padding-left:30px;}
login_block_left{$id} {text-align:left;}
login_block_left{$id} * {margin-left:5px;}
menu_block{$id} {{BEGIN LTR_block}margin-left:10px;{END LTR_block}{BEGIN RTL_block}float:right;margin-right:10px;{END RTL_block}}
recordcontrols_block{$id} {padding:10px 10px;text-align:center;vertical-align:middle;}
record_controls{$id} > ,#newrecord_controls{$id} > {margin:2px 2px;vertical-align:middle}
grid_block{$id} {margin-top:2px;}
linebody{$id} {height:10px;}
.message_block {text-align:center;padding:5px}
.grid_recordheader {padding:0 5px 5px}
.grid_recordheader a {margin:0px 5px;}
form#frmAdmin{$id} {display:inline;}
aftermenu{$id} {clear:left;height:1px;overflow:hidden}
body{margin:0px;padding:0px;}
searchOptions{$id}{
margin-right: 10px;
padding-bottom: 18px;
}
searchform{$id}{
float: left;
}
searchPanelContainer{$id}{
width: 200px;
display: block;
position:absolute;
}
/report styles/
export_links{$id} * {padding:0}
</style>
{END style_block}
</head>
<body marginheight=0 marginwidth=0 {$bodyattrs}>
{BEGIN body}
<div id="height100{$id}">
{$header}
{BEGIN toplinks_block}
<div id="toplinks_block{$id}">
<span id="login_block_left{$id}">
Logged on as <b>{$username}</b>
<a href="login.asp?a=logout" {$logoutlink_attrs}>Log out</a>
</span>
<span id="login_block_right{$id}">
{BEGIN asearch_link}
<a href="ClientIndex_search.asp" {$advsearchlink_attrs}>Advanced search</a>
{END asearch_link}
<!--language-->
</span>
</div>
{END toplinks_block}
<!-- MenuBegin -->
<!-- MenuEnd -->
<div id="aftermenu{$id}"></div>
{BEGIN search_records_block}
<div id="search_records_block{$id}" class="main_table_border_P">
{BEGIN searchform}
<!-- Search panel header for horizontal layouts -->
<span id="searchform{$id}" align="absmiddle">
<span id="searchPanelHeader{$id}">
{$simpleSearchFieldCombo}
{$simpleSearchTypeCombo}
{BEGIN searchform_text}
<input type="text" {$searchfor_attrs} size="25">
{END searchform_text}
{BEGIN searchform_search}
<span class="buttonborder"><input class="button" type="button" style="width: 18px; background-image: url(images/search/search.gif);" {$searchbutton_attrs} ></span>
{END searchform_search}
{BEGIN searchform_showall}
<span id="showall{$id}" class="buttonborder"><input type="button" class="button" value="Show all" {$showallbutton_attrs}></span>
{END searchform_showall}
</span>
{BEGIN searchPanelTopButtons}
<span>
<span class="buttonborder"><input class="button" type="button" id="showSrchWin{$id}" style="width: 18px; background-image: url(images/search/showWindowPin.gif);" {$showHideSearchWin_attrs} ></span>
<span class="buttonborder"><input class="button" type="button" id="showOptPanel{$id}" style="width: 18px; background-image: url(images/search/showOptions.gif);" {$showHideSearchPanel_attrs} ></span>
</span>
{END searchPanelTopButtons}
</span>
{END searchform}
<span>
{BEGIN details_block}
<span id="detFound{$id}">Details found: <b>{$records_found}</b> </span>
{END details_block}
{BEGIN pages_block}
<span id="pageOf{$id}">Page <b>{$page}</b> of <b>{$maxpages}</b></span>
{END pages_block}
{BEGIN recordspp_block}
<span id="recordspp_block{$id}">
Records Per Page:
<select {$recordspp_attrs}>
<option value="10" {$rpp10_selected}>10</option>
<option value="20" {$rpp20_selected}>20</option>
<option value="30" {$rpp30_selected}>30</option>
<option value="50" {$rpp50_selected}>50</option>
<option value="100" {$rpp100_selected}>100</option>
<option value="500" {$rpp500_selected}>500</option>
</select>
</span>
{END recordspp_block}
</span>
</div>
{END search_records_block}
<!-- search panel and window -->
<div id="searchPanelContainer{$id}" class="searchPanelContainer">
{$adv_search_panel}
</div>
<div moveForSearch="move{$id}" {$marginStyle}>
<table class="tableborder" {$gridTable_attrs} cellspacing=0 cellpadding=0 ><tr><td class="tableborder1">
{BEGIN recordcontrols_block}
<div id="recordcontrols_block{$id}" class="body2">
{BEGIN record_controls}
<span id="record_controls{$id}">
</span>
{END record_controls}
</div>
{END recordcontrols_block}
<div class="message" id="usermessage{$id}">{$user_message}</div>
{BEGIN grid_block}
<div id="grid_block{$id}">
<table name="maintable" class="data" align="center" width="100%" border="0" cellpadding=3 cellspacing=0>
{BEGIN grid_header}
<thead>
<tr class="blackshade" valign="top" {$gridHeader_attrs}>
{BEGIN record_header}
{BEGIN dbo_ClientIndex_dtable_column}
<th align="center" class="headerlist"> </th>
{END dbo_ClientIndex_dtable_column}
{BEGIN Client_ID_fieldheadercolumn}
<th class="headerlist" align="center">
{BEGIN Client_ID_fieldheader}
<a class="tablelinks"
{$Client_ID_orderlinkattrs}>
</a>
{END Client_ID_fieldheader}
</th>
{END Client_ID_fieldheadercolumn}
{BEGIN NHS_Nofieldheadercolumn}
<th class="headerlist" align="center">
{BEGIN NHS_No__fieldheader}
<a class="tablelinks"
{$NHS_Noorderlinkattrs}>
NHS No.</a>
{END NHS_Nofieldheader}
</th>
{END NHS_No__fieldheadercolumn}
{BEGIN Title_fieldheadercolumn}
<th class="headerlist" align="center">
{BEGIN Title_fieldheader}
<a class="tablelinks"
{$Title_orderlinkattrs}>
Title</a>
{END Title_fieldheader}
</th>
{END Title_fieldheadercolumn}
{BEGIN First_Name_fieldheadercolumn}
<th class="headerlist" align="center">
{BEGIN First_Name_fieldheader}
<a class="tablelinks"
{$First_Name_orderlinkattrs}>
First Name</a>
{END First_Name_fieldheader}
</th>
{END First_Name_fieldheadercolumn}
{BEGIN Surname_fieldheadercolumn}
<th class="headerlist" align="center">
{BEGIN Surname_fieldheader}
<a class="tablelinks"
{$Surname_orderlinkattrs}>
Surname</a>
{END Surname_fieldheader}
</th>
{END Surname_fieldheadercolumn}
{BEGIN Address_fieldheadercolumn}
<th class="headerlist" align="center">
{BEGIN Address_fieldheader}
<a class="tablelinks"
{$Address_orderlinkattrs}>
Address</a>
{END Address_fieldheader}
</th>
{END Address_fieldheadercolumn}
{BEGIN AddressLine2_fieldheadercolumn}
<th class="headerlist" align="center">
{BEGIN AddressLine2_fieldheader}
<a class="tablelinks"
{$AddressLine2_orderlinkattrs}>
Address Line2</a>
{END AddressLine2_fieldheader}
</th>
{END AddressLine2_fieldheadercolumn}
{BEGIN PostCode_fieldheadercolumn}
<th class="headerlist" align="center">
{BEGIN PostCode_fieldheader}
<a class="tablelinks"
{$PostCode_orderlinkattrs}>
Post Code</a>
{END PostCode_fieldheader}
</th>
{END PostCode_fieldheadercolumn}
{BEGIN Date_of_Birth_fieldheadercolumn}
<th class="headerlist" align="center">
{BEGIN Date_of_Birth_fieldheader}
<a class="tablelinks"
{$Date_of_Birth_orderlinkattrs}>
Date of Birth</a>
{END Date_of_Birth_fieldheader}
</th>
{END Date_of_Birth_fieldheadercolumn}
{BEGIN Ethnicity_fieldheadercolumn}
<th class="headerlist" align="center">
{BEGIN Ethnicity_fieldheader}
<a class="tablelinks"
{$Ethnicity_orderlinkattrs}>
Ethnicity</a>
{END Ethnicity_fieldheader}
</th>
{END Ethnicity_fieldheadercolumn}
{BEGIN Nationality_fieldheadercolumn}
<th class="headerlist" align="center">
{BEGIN Nationality_fieldheader}
<a class="tablelinks"
{$Nationality_orderlinkattrs}>
Nationality</a>
{END Nationality_fieldheader}
</th>
{END Nationality_fieldheadercolumn}
{BEGIN Marital_Status_fieldheadercolumn}
<th class="headerlist" align="center">
{BEGIN Marital_Status_fieldheader}
<a class="tablelinks"
{$Marital_Status_orderlinkattrs}>
Marital Status</a>
{END Marital_Status_fieldheader}
</th>
{END Marital_Status_fieldheadercolumn}
{BEGIN Date_of_Death_fieldheadercolumn}
<th class="headerlist" align="center">
{BEGIN Date_of_Death_fieldheader}
<a class="tablelinks"
{$Date_of_Death_orderlinkattrs}>
Date of Death</a>
{END Date_of_Death_fieldheader}
</th>
{END Date_of_Death_fieldheadercolumn}
{BEGIN GP_Code_fieldheadercolumn}
<th class="headerlist" align="center">
{BEGIN GP_Code_fieldheader}
<a class="tablelinks"
{$GP_Code_orderlinkattrs}>
GP Code</a>
{END GP_Code_fieldheader}
</th>
{END GP_Code_fieldheadercolumn}
{BEGIN GP_fieldheadercolumn}
<th class="headerlist" align="center">
{BEGIN GP_fieldheader}
<a class="tablelinks"
{$GP_orderlinkattrs}>
GP</a>
{END GP_fieldheader}
</th>
{END GP_fieldheadercolumn}
{BEGIN endrecordheader_block}
<th class="body2"></th>
{END endrecordheader_block}
{END record_header}
</tr>
</thead>
{END grid_header}
<tbody>
{BEGIN grid_row}
<tr valign="top" {$rowstyle} {$rowattrs}>
{BEGIN grid_record}
{BEGIN dbo_ClientIndex_dtable_column}
<td align="left" valign="middle" class="borderbody" nowrap="nowrap">
{BEGIN CPACareCoordinator_dtable_link}
<a {$CPACareCoordinator_dtablelink_attrs}>Care Coordinator
<span {$CPACareCoordinator_childnumber_attr}>{BEGIN CPACareCoordinator_childcount}({$CPACareCoordinator_childnumber}){END CPACareCoordinator_childcount}</span>
</a>
{END CPACareCoordinator_dtable_link}
{BEGIN DiagnosisClient_dtable_link}
<a {$DiagnosisClient_dtablelink_attrs}>Diagnosis
<span {$DiagnosisClient_childnumber_attr}>{BEGIN DiagnosisClient_childcount}({$DiagnosisClient_childnumber}){END DiagnosisClient_childcount}</span>
</a>
{END DiagnosisClient_dtable_link}
{BEGIN AmsReferral_dtable_link}
<a {$AmsReferral_dtablelink_attrs}>Referrals
<span {$AmsReferral_childnumber_attr}>{BEGIN AmsReferral_childcount}({$AmsReferral_childnumber}){END AmsReferral_childcount}</span>
</a>
{END AmsReferral_dtable_link}
{BEGIN EPClientPrescription_dtable_link}
<a {$EPClientPrescription_dtablelink_attrs}>Prescription
<span {$EPClientPrescription_childnumber_attr}>{BEGIN EPClientPrescription_childcount}({$EPClientPrescription_childnumber}){END EPClientPrescription_childcount}</span>
</a>
{END EPClientPrescription_dtable_link}
{BEGIN EPClientMedication_dtable_link}
<a {$EPClientMedication_dtablelink_attrs}>Medication
<span {$EPClientMedication_childnumber_attr}>{BEGIN EPClientMedication_childcount}({$EPClientMedication_childnumber}){END EPClientMedication_childcount}</span>
</a>
{END EPClientMedication_dtable_link}
{BEGIN ImsEventMovement_dtable_link}
<a {$ImsEventMovement_dtablelink_attrs}>Inpatient History
<span {$ImsEventMovement_childnumber_attr}>{BEGIN ImsEventMovement_childcount}({$ImsEventMovement_childnumber}){END ImsEventMovement_childcount}</span>
</a>
{END ImsEventMovement_dtable_link}
{BEGIN MntClientAwol_dtable_link}
<a {$MntClientAwol_dtablelink_attrs}>Awol History
<span {$MntClientAwol_childnumber_attr}>{BEGIN MntClientAwol_childcount}({$MntClientAwol_childnumber}){END MntClientAwol_childcount}</span>
</a>
{END MntClientAwol_dtable_link}
{BEGIN MntClientSectionDetail_dtable_link}
<a {$MntClientSectionDetail_dtablelink_attrs}>Section Details
<span {$MntClientSectionDetail_childnumber_attr}>{BEGIN MntClientSectionDetail_childcount}({$MntClientSectionDetail_childnumber}){END MntClientSectionDetail_childcount}</span>
</a>
{END MntClientSectionDetail_dtable_link}
{BEGIN RskRelatedIncidents_dtable_link}
<a {$RskRelatedIncidents_dtablelink_attrs}>Rsk Related Incidents
<span {$RskRelatedIncidents_childnumber_attr}>{BEGIN RskRelatedIncidents_childcount}({$RskRelatedIncidents_childnumber}){END RskRelatedIncidents_childcount}</span>
</a>
{END RskRelatedIncidents_dtable_link}
{BEGIN UserAssessriskass_dtable_link}
<a {$UserAssessriskass_dtablelink_attrs}>Risk Assessment
<span {$UserAssessriskass_childnumber_attr}>{BEGIN UserAssessriskass_childcount}({$UserAssessriskass_childnumber}){END UserAssessriskass_childcount}</span>
</a>
{END UserAssessriskass_dtable_link}
{BEGIN AmsAppointmentContact_dtable_link}
<a {$AmsAppointmentContact_dtablelink_attrs}>Appointments
<span {$AmsAppointmentContact_childnumber_attr}>{BEGIN AmsAppointmentContact_childcount}({$AmsAppointmentContact_childnumber}){END AmsAppointmentContact_childcount}</span>
</a>
{END AmsAppointmentContact_dtable_link}
{BEGIN PrgProgressNote_dtable_link}
<a {$PrgProgressNote_dtablelink_attrs}>Prg Progress Note
<span {$PrgProgressNote_childnumber_attr}>{BEGIN PrgProgressNote_childcount}({$PrgProgressNote_childnumber}){END PrgProgressNote_childcount}</span>
</a>
{END PrgProgressNote_dtable_link}
</td>
{END dbo_ClientIndex_dtable_column}
{BEGIN Client_ID_fieldcolumn}
<td valign=middle class=borderbody {$Client_ID_style}>
{$Client_ID_value}
</td>
{END Client_ID_fieldcolumn}
{BEGIN NHS_Nofieldcolumn}
<td valign=middle class=borderbody {$NHS_Nostyle}>
{$NHS_No__value}
</td>
{END NHS_Nofieldcolumn}
{BEGIN Title_fieldcolumn}
<td valign=middle class=borderbody {$Title_style}>
{$Title_value}
</td>
{END Title_fieldcolumn}
{BEGIN First_Name_fieldcolumn}
<td valign=middle class=borderbody {$First_Name_style}>
{$First_Name_value}
</td>
{END First_Name_fieldcolumn}
{BEGIN Surname_fieldcolumn}
<td valign=middle class=borderbody {$Surname_style}>
{$Surname_value}
</td>
{END Surname_fieldcolumn}
{BEGIN Address_fieldcolumn}
<td valign=middle class=borderbody {$Address_style}>
{$Address_value}
</td>
{END Address_fieldcolumn}
{BEGIN AddressLine2_fieldcolumn}
<td valign=middle class=borderbody {$AddressLine2_style}>
{$AddressLine2_value}
</td>
{END AddressLine2_fieldcolumn}
{BEGIN PostCode_fieldcolumn}
<td valign=middle class=borderbody {$PostCode_style}>
{$PostCode_value}
</td>
{END PostCode_fieldcolumn}
{BEGIN Date_of_Birth_fieldcolumn}
<td valign=middle class=borderbody {$Date_of_Birth_style}>
{$Date_of_Birth_value}
</td>
{END Date_of_Birth_fieldcolumn}
{BEGIN Ethnicity_fieldcolumn}
<td valign=middle class=borderbody {$Ethnicity_style}>
{$Ethnicity_value}
</td>
{END Ethnicity_fieldcolumn}
{BEGIN Nationality_fieldcolumn}
<td valign=middle class=borderbody {$Nationality_style}>
{$Nationality_value}
</td>
{END Nationality_fieldcolumn}
{BEGIN Marital_Status_fieldcolumn}
<td valign=middle class=borderbody {$Marital_Status_style}>
{$Marital_Status_value}
</td>
{END Marital_Status_fieldcolumn}
{BEGIN Date_of_Death_fieldcolumn}
<td valign=middle class=borderbody {$Date_of_Death_style}>
{$Date_of_Death_value}
</td>
{END Date_of_Death_fieldcolumn}
{BEGIN GP_Code_fieldcolumn}
<td valign=middle class=borderbody {$GP_Code_style}>
{$GP_Code_value}
</td>
{END GP_Code_fieldcolumn}
{BEGIN GP_fieldcolumn}
<td valign=middle class=borderbody {$GP_style}>
{$GP_value}
</td>
{END GP_fieldcolumn}
{BEGIN endrecord_block}
<td class="body2" {$endrecordblock_attrs}></td>
{END endrecord_block}
{END grid_record}
</tr>
{END grid_row}
</tbody>
</table>
</div>
{END grid_block}
{BEGIN pagination_block}
<div id="pagination_block{$id}" class="toplist message_block main_table_border_P">{$pagination}</div>
{END pagination_block}
{BEGIN message_block}
<div class="toplist message_block main_table_border_P"><b>{$message}</b></div>
{END message_block}
</td></tr></table>
</div>
{$footer}
</div>
{END body}
</body>
</html>