Hello,

I was reading VFP 6.0 book and came across a word "surrogate key"
The book explains that this key is an independent key generated
by program behind the scene rather than by the users. The users never see this key.

I am not quite sure why this usage of surrogate key is better than a key entered by the users and if so how one should generate it. Should one use random number generator or some such thing.

If anyone who is familiar with the use and creation of surrogate
key, please help. If you kindly use some example to explain
why it might be better to use a surrogate key, I am obliged.

Aiko@washington