Search results for query: *

Humm, sort of. I may have put the problem the wrong way. Here's what I want: catID catName parentID ------------------------------ 1 Vehicle (NULL) 2 Computer (NULL) 3 Books (NULL) 4 Car Vehicle 5 Motorcycle Vehicle 6...

I just want that when the record does have parentID instead of appearing parentID, to appear the parents name. Like in my example from above, instead of showing: 5 - Motorcycle - 1 To appear: 5 - Motorcycle - Vehicle It can be on a dbcombo box, dbEdit whatever, I don't really care and I can...

Hi all, This may be a really noobish doubt, but still I need to know. I have this table which is something like: tableCat ----------- catID, primary key catName parentID Which is something like, if the record doesn't have a parentID (which refers an catID), then the record is a category...