>This seems line an elementary question, but it's got me a bit puzzled. When the user is entering a new record, how do you check to be sure a field doesn't have a duplicate value without moving the record pointer?

>Michelle


Michelle, this suggestion has already been made so I'm just going to reiterate it. I have a number of lookup routines for key fields as methods of my main app (goApp). These methods always execute in the default datasession (1). A new record would be entered in a form which has its own datasession. So I'm always free to pass the entered value to the goApp.MyLookup() method to see if it is already present without disturbing the form in any way.

Bear in mind that it won't find a record which is still in your input buffer.

I think this is the most straightforward and general approach.

Peter