Avatar

Level 2

Paul - that tip on the web cast was great! Many thanks

I have the first criteria working with the code that you provided.

Question on an enhancement to your code.

I have the first filter working, say CompanyID

I need to have 2 more filters, Year, and Project where the relation between Company and year and year and Prroject are both one to many

So the initial filter by Company works fine, now how do I get a drop down to show the Years available for the company selected

Below, I was trying to just get the 2nd filter to work.

I am using your code from te drop down list in the 4-Populate+DD+then+select+specific+record.pdf example

I thought it would be simply copy your code and use the following right after the first variable was selected:

while(xfa.sourceSet.nodes.item(nIndex).name != "ClientYears")

oDB.nodes.item(1).query.select.nodes.item(0).value = "Select * from ClientYears where ClientID = '" + inName + "'";

Where inName is the CompanyID from the first selected criteria and the CLientYears is the table with the years that are appropriate.

However not working, the last line of code above (in blue) turn blue (not normal black) for some reason....