johnblack - 6:20 am on Feb 16, 2011 (gmt 0)
I may have got the wrong end of the stick but it sounds as if 'faultdatabase' in your opening post is table of faults which have a specific 'faulttype' i.e. One fault type can be applied to many faults.
If you are trying to populate a combobox from which the user selects a fault type for a given fault, then
Select distinct faulttype from faultdatabase is what you are after.
With regard to the id on the combobox, some databases would use a separate table to hold the distinct fault types, call it 'faulttypes' with a primary key of 'faulttypes_id'. So to populate the combobox you would use the query
Select faulttypes_desc, faulttypes_id from faulttypes
where the 'id' on the combobox is faulttypes_id.
Back on the fault table, instead of a 'faulttype' field there would be a foreign key to the faulttypes table, say 'faulttypes_fk_id'
The idea is that the combobox provides an 'id' for the faulttypes table which is stored in the faulttypes_fk_id column when the fault is updated or created by the application.
Hope that all makes sense!