Here is a snippet
<cf_DisplayList table="SVR_SLA_HISTORY" rowsPerPage="20" label="SLA
History"
displayALinkToThisSearchForm="SVR_SLA_HISTORYSearchForm.cfm">
<cf_PrimaryKey primaryKeyColumn="SLA_HISTORY_ID" primaryKeyType="varchar(100)">
<cf_JoinToParent table="SVR_SUP_SLATYPE" primaryKeyColumn="SLA_ID" foreignKeyColumn="OLD_SLA_ID">
<cf_DisplayColumnInList table="SVR_SUP_SLATYPE" column="TYPE" label="Old SLA Type" type="varchar(100)">
<cf_DisplayColumnInList column="CHANGE_DATE" label="Date Changed" type="datetime">
What I have in PLUM is a another column called "NEW_SLA_ID" which
is also a FK of SVR_SUP_SLATYPE, when generated this is totally left
out. What is the correct way to join 2 columns to 1 parent?
More example.
OLD_SLA_ID = 2 when joined to parent 2 = "SuperDooper"
NEW_SLA_ID = 5 when joined to parent 5 = "SuperSucky"
I tried with no luck. It displays OLD_SLA_ID's referenced value for both.
<cf_JoinToParent table="SVR_SUP_SLATYPE" primaryKeyColumn="SLA_ID" foreignKeyColumn="OLD_SLA_ID">
<cf_DisplayColumnInList table="SVR_SUP_SLATYPE" column="TYPE" label="Old SLA Type" type="varchar(100)">
<cf_JoinToParent table="SVR_SUP_SLATYPE" primaryKeyColumn="SLA_ID" foreignKeyColumn="NEW_SLA_ID">
<cf_DisplayColumnInList table="SVR_SUP_SLATYPE" column="TYPE" label="New SLA Type" type="varchar(100)">
any help is appreciated
--
Tim Blankenship
[EMAIL PROTECTED]
www.vespri.com
