I have a a list (Office) that is a child of 3 parents (Company,
StateProvince, and Country). It has an embedded search form on the
Office.OfficeName field. I notice I am getting mulitple JoinToParent
calls in the OfficeList.cfm file for the Company relation.
<cf_DisplayList table="Office" rowsPerPage="10" label="Offices"
displayALinkToThisSearchForm="No">
<cf_PrimaryKey primaryKeyColumn="OfficeID" primaryKeyType="integer">
<cf_JoinToParent table="Company" primaryKeyColumn="CompanyID"
foreignKeyColumn="CompanyID">
<cf_JoinToParent table="Company" primaryKeyColumn="CompanyID"
foreignKeyColumn="CompanyID">
<cf_JoinToParent table="StateProvince"
primaryKeyColumn="StateProvinceID" foreignKeyColumn="StateProvinceID">
<cf_JoinToParent table="Country" primaryKeyColumn="CountryID"
foreignKeyColumn="CountryID">
<cf_JoinToParent table="Company" primaryKeyColumn="CompanyID"
foreignKeyColumn="CompanyID">
<cf_DisplayColumnInList table="Company" column="CompanyName"
label="Company Name" type="varchar(50)">
<cf_DisplayColumnInList column="OfficeName" label="Office Name"
type="varchar(50)">
One should be enough, shouldn't it?
Jeff
--
_______________________________
Jeff Fleitz
Tekquest, Ltd
Integrated Digital Solutions
http://www.tekquest.com
_______________________________
