I don't know if this problem is related to the drilldowns/ups so I'll
post it. This is all latest build and I have generated the tags several
times.
I am playing with a MasterDetail View form that has a DisplaySpouses tag
call on it (works fine), and a list to a child. This is based on the
Company -> Office parent child relationship I have been testing with
recently.
When I go into the view form, the Office List I built displays rows from
all companies, instead of from the company I am viewing. I couldn't
figure out why it is not being filtered, and could not find any
references to the problem, so I manually added a
whereClauseExtension="Office.CompanyID = #URL.CompanyID#" for grins. I
should not have to use this attribute, correct?
This worked, but if I returned to the Company list, selected a different
company to view, the filter criteria from the first call is sticking,
and the filter criteria from the second view call is appended to the
end. See SQL below for example.
SELECT Office.OfficeName AS Office_OfficeName,Office.Headquarters AS
Office_Headquarters,StateProvince.Abbrev AS
StateProvince_Abbrev,Country.Country AS Country_Country,Office.OfficeID
AS Office_OfficeID,Office.CompanyID AS
Office_CompanyID,Office.StateProvinceID AS
Office_StateProvinceID,Office.CountryID AS Office_CountryID FROM
((Office INNER JOIN Company ON Office.CompanyID = Company.CompanyID)
LEFT OUTER JOIN StateProvince ON Office.StateProvinceID =
StateProvince.StateProvinceID) LEFT OUTER JOIN Country ON
Office.CountryID = Country.CountryID WHERE 1 > 0 AND Office.CompanyID =
1 AND Office.CompanyID = 4 AND Office.CompanyID = 1 ORDER BY
Office.OfficeName ASC
I have to click the list links on the navbar, where refresh=1 to clear
the criteria and start over, otherwise errors are generated.
Is this related to what David is re-engineering right now? I didn't
install the tutorial, but I gather the example in the help file must work?
Jeff
--
_______________________________
Jeff Fleitz
Tekquest, Ltd
Integrated Digital Solutions
http://www.tekquest.com
_______________________________
