Hi, I've used TwoSelectsRelated tag before - but for some reason can't get it working on another section of my site. I have a table, locations, with "County" and "Town" - I've populated one of the select with counties, but the second isn't being populated. I think it's probably due to my query, not having a "where" in it - but I don't understand how I *can* put in a "where" statement, nor why I'd need one. Should I create another table with all the counties in it, and link that to the existing table? If anyone can work out what I need to, it'd be greatly appreciated (code shown below), Thanks Will <cfquery name="findcats" datasource="localads"> SELECT county,town FROM Locations ORDER by county </cfquery> <CF_TwoSelectsRelated QUERY="findcats" NAME1="thecounty" NAME2="thetown" DISPLAY1="county" DISPLAY2="town" VALUE1="county" VALUE2="town" FORCEWIDTH1="70" FORCEWIDTH2="70" SIZE1="1" SIZE2="1" HTMLBETWEEN="<BR>" AUTOSELECTFIRST="Yes" EMPTYTEXT1="(choose a county)" EMPTYTEXT2="(now choose a town)" ONCHANGE="" FORMNAME="MyOtherForm"> ------------------------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
