I have a visual basic 6 application and a table having staff names (surname, First Name and Middle Name )
I need to be able able to load the names sort alphabetically
The Nodes will be the alphabets ( A, B ......... Z)
So every one whose surname starts with A will be listed together under Node A
But for all people under Node 'A' they will be listed sorted alphabetically
Same rule will apply for Nodes 'B' to 'Z'
Has any body a clue what I should do. Sample code if available will be very helpful