thanks for the clarity, I have just gone cross eyed trying to understand what the manual says about using DISTINCT in a conditional query, I'm more confused now..
Ideally I would like the column 'faulttype' to return NO duplicates, and for the ID's associated with the returned data to remain intact - this is for a VB.net ADODB recordset project for work, and when your populating a combobox, part of the object requires an index('id') so that when it's selected, there is a value there.
I shall try a few more combinations, but 10:20PM I think I am going to call it a night. I need caffine & food.
[EDIT] Ok, I have commented out the index object from the loop, and I shall see if I can get away with passing it as a string value & not an integer, hopefully this won't fudge things up too much...
So close to a working 'prototype' version...
Cheers for the advice anyway,