>In SELECT with GROUP BY anybody knows how to generate a group number?
>Something like this:
>1 Ford
>2 Nissan
>3 BMW
>Thanks Mark

Here's another way. (More work, but more flexible)

LOCAL liKeynum
liKeynum = 0

SELECT GetKey(liKeynum) AS thekey, *


*******************

FUNCTION GetKey
LPARAMETER tikeynum

RETURN tiKeynum + 1



-Michelle