>Is SET EXACT ON? If not, maybe it did find a matching record (ex: Tommy = Tom yield True).
>
>I would suggest a different route: since this field must be unique, create a candidate index on ID_No. After that, you just need to trap the result from TableUpdate().
Hi Sylvain,
I don't think the field needs to be a candidate, I have a primary key in the table already. I would like to let the user know that there is a conflict with the ID number though. There are approx 800 drawings that need to be entered into the table and all have their own ID already. There may be problems that surface when inputting that need to addressed. The problem is that when the valid returns .t. it doesn't tab off the field.
Jim Philippi
quando omni flunkus moritati