>Hi, i am wondering...i am reletively new to foxpro and was wondering if there was a way to put a table of 50 different records into groups of 2. example: i have 50 people and i want to divide them up into 25 groups of 2, where the group of 2 is generated randomly. so in essence what i'm looking for is a command that will generate random numbers, creating tables where the same 2 people are not paired up every time.

Hi Erin see the RAND() function this can do the work.