Hi Dan, yes i am using the group in cfoutput but because i
only want to display Part Numbers that only have the model numbers
that the user has selected.
so if a user selects model EXH130
it will show all Part No like this
034444 model EXH130, 150, GFF170
034445 model EXH120, EXH130, GFF170
so it shows all model numbers not just the users selection
what it is now
http://www.southerncooling.com/ProductResults1.cfm
in my query i have
AND MT.Model_ID = '#session.ModelNo#'
this stops all the model numbers showing, can i have
something instead saying
where '#session.ModelNo#' appears in MT.Model_ID