>>>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
>>
>>
>>You don't need to use memory variables. Buffering will handle that for you. The triggers will fire when you commit the changes. Your primary key should be something that the user never needs to see -- internal to the system.
>
>Thank you craig for the suggestion. But I am not using surrogate keys.
>
>alex
\

I think you're going to shoot yourself in the foot by allowing the user to enter a primary key. You can still
let them enter a key value, and they can use it, but you should have something that the program creates that
will be unique each time that you can use as a primary key.