I got this off the UT. Enjoy.

>Can anyone give me the skinny on how this works? (Behind-the-scenes stuff.)

>

>Thanks in Advance.

There is a tiny mouse cage. In the cage is a spinning wheel. There is also a

lepracan. When you add a record the lepracan temps the mouse with a piece of

magic cheese. This causes the mouse to run in the wheel, and VFP counts the

wheel rotations. The lepracaun just knows by magic when to give the mouse

the cheese... so, you get the next id.

Actually, I believe a few bytes unused in the .dbf header was stolen to

store the next id value. If you already have values, when you change the

type to auto-increment you can specify the 'next id' so it wont conflict

with your existing numbers.

Bob Archer

Stephen Russell

President

S.R. & Associates

Memphis TN

901.246-0159