sorting

[axis]

hi,

thanks to you good folks and all your help i have a little rdbs going!

however, when i sort -in a Table view- by "Username", in this case, i get about half or so of my records sorted, then there is the rest of the records sorted, by Username, again.

this seems to be because those Usernames that are appearing in the "latter sorted section" are also Users who listed in the first, i.e., i have Usernames appearing multiple times -which is fine, BUT in a sort by Username is seems that it does each name once then the multiples appear (sorted) -even if there are 2 more occurances of the same Username they WILL then be "together".

how can i get them ALL together?

i can't seem to use the User ID because i want them to be alphabetical and some IDs are created, naturally, after others.

i don't understand why a Username sort isn't producing the desired aphabetical listing despite multiple entries of the same name (same ID).

here is an illustration with 4 Usernames -9 records:

user1

user2

user3

user4

user2

user3

user3

user4

user4

i want them to all be together, i.e., 1,2,2,3,3,3,4,4,4.

what could be some possible causes for all of the records not being "sorted together"?

any ideas at all? what might i look for?

i would LOVE to send this small file to someone to advise me just a bit -i would learn SO much!

use no spaces: g e t 8 6 @ m a c . c o m

(if you would have a look?)

TIA

[ October 17, 2001: Message edited by: axis ]

[ October 17, 2001: Message edited by: axis ]

[ October 17, 2001: Message edited by: axis ]

[ October 17, 2001: Message edited by: axis ]

[BruceJ]

I'd bet ya a dozen doughnuts it's something pretty simple, but a littel evasive. Check your mail. I'll give it a go if you want to send it to me.