VFP 6.0

I have come to the point where I may be confused with how to program with Primary key, multi-users, (maybe) OOP, etc... I have MS VFP 6.0 Programmer's Guide and have read some other books, so I am not interested in buying a new book. If you could help me find it in MS (VFP) online Help article (or in my MS Programmer's Guide book) where I can read about how to best use uniquely the ID's (which I thought the Primary key was supposed to do that, but appearly not). I need to study (and program the coding) how to work with when allowing the user to input the ID, then check if this ID exist (via, if yes-> error message, if no-> enable the rest of the fields). But that's not done yet, I need to somehow "double-check" if another user in multi-network is using the same ID (highly unlikely, but still) so I can program to inform (either or both or whatever) that there is a possibly of duplicating ID. Maybe the only way is to catch this is when one of them saved the record, then the "next/last" user will be prompted with the error message?

We did hired a consultant and this person is pretty good, but keeps reading the help files all the time and asks me, "Wow, thats nice, how to do that", stuff like that... Furthermore, I have CodeMine 6.1 framework, it is somewhere behind me (don't have that much of understanding of VFP).

Keep in mind that I am former FPW 2.6 and I do very well with that, so stepping into VFP 6.0 for a while was a challenge, but I don't want to give up. Also, (not your fault <g>) I need to do this in timely manner (I am in the middle of the project right now and I am just like a sitting duck).

Thank you.

Chuck