Hiya Craig ---
>
>How much space does it take to store your GUID? Integers are small and VERY fast. Faster than character.
See my reply to Erik...it's not that I have a problem with integer keys, conceptually, it's just that they have to be managed at the program level in VFP and not internal to the database engine, therefore, the potential for conflict exists.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05