Hiya Craig ----
I hate @*#^@^&# integers :-)
I used to use SYS(3), then went to SYS(2015) and now I'm quite happy generating GUIDs for primary keys.....any system which relies on an incremented number, in VFP, is suspect IMHO...now in SQL that's a different story.
>
>Actually, Mac went into great detail about why integer is better than character. There is an article on my website that discusses primary keys.
------------------------------------------------
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
