>Does anyone know how I can create an index that would allow me to set a random order? Thanks,
>John
John,
I'm not sure why you want this but, try:
=rand(-1) && seed the random number generator
index on int(recc()*rand()) tag randtag && build index nodes using a random number based on number of records in table
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao