Dear all,

I have a table. When the user adds a new record, I want to check if this new record (for example, same UserID) has already exist in the table or not. How can I do that?
I found in an example that it has a "Save" button and the CLICK event is:
result = TABLEUPDATE(.F.) if result = .F. =MESSAGEBOX("Fail to save!"+CHR(13)+"User ID already exists";
else
....
...
It works in this example. I have tried to find any coding for checking about the existing data in this example but cannot find any idea.
Anyone can help?

Thanks
Power