I'm pulling organisation names from a Person table and am getting repeating responses in the drop down list. eg. Computing, Computing, Gardening, Sage, Computing. How do i get single responses for each type?
I think you need a "DISTINCT" keyword in your SQL SELECT statement.<BR><BR>Post your current SQL statement here and I'll have a look.<BR><BR>Craig.
Ooooh I could have answered that one :) must be finally learning something...yay :D<BR><BR>Matt