i have a recordset filtering products by category: something like mountain, freestyle, route,etc
then i have one recordset filtering products by line: something like Bikes, wheels, accesories,etc.

i would like to use the search by category: mountain, and then cross it with the lines: bikes
the results page should show all the mountain bikes

how do i filter both recordsets??

Everybody should belive in something... I belive i'm having another beer

I think you JOIN the tables in the SQL

There is some help on this at:
www.macromedia.com/support/ultradev/ts/documents/concatenatingdates.htm

its not an exact emaple of what you want but it will point you in the right direction. Hope it helps

"Nobody ever said this stuff was easy"

Thanks D

as you said was not exactly what i was trying to acomplish but i got the idea, now I'm working on it. cool

Everybody should belive in something... I belive i'm having another beer