>>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