>Thank you, i will try it
Well, I miss a KEY point to you!
* At TxtNewKey.LostFocus
Select RWCopy
mainKeyName = Field(1) && Suppose the Primary Key is 1st field!
REPLACEMACRO = [Replace &mainKeyName With ] + ALLTRIM(this.value)
&REPLACEMACRO
So, you don't make error on append as Duplicate mainKey!!
^_~ Try your best!!
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.