>>>Hi.,
>>>
>>>I am a new entrant to these forums and Visual Foxpro. I just want to know whether anybody can
>>>help me with the following how to:
>>>
>>> I am creating a form based on a table with row buffering. I want the form to check the entry
>>>in the primary key field as soon as the operator leaves the field while in add routine.
>>>
>>> Also I would like to know whether I can change the control source of the fields for add routines
>>>to the memory fields and for all other purpose the base table fields as the control source.
>>>
>>>Thanks in advance. By the way I found a message in my name without myself ever knowing it ?
>>>Is such a thing possible as this is my first ever message to this forum.
>>>
>>>alex
>>Hi alex,
>>
>>I too, am very new to vfp, but I can answer your question. As long as your table has the index set as primary and you have your form set to row buffering, vfp will do this automatically. I have set up several forms like this. It also helps if you use the buttons from the wizard class that autmatically move through any table attached to a form. They allow adds, edits and deletes and ms wrote all the code for you already.
>>
>>Audie
>
>Hi Audie,
>
>Thanks. But I am looking for a way to get a warning just as the user leaves the field. I am not for the vfp
>way. My question is - Is there a way to get the duplicated warning immediately after leaving the field in a
>form.??. I am not using the surrogate keys.
>
>Thanks
>
>alex

Visual MaxFrame is a public domain framework that contains a .PRG that does what you're looking for (X3CKCHEK.PRG). You can get it at www.maxlink.com. I use the commercial version (US $349), and highly reccomend it.