>I've created a local view in my database for use in a grid for displaying and updating native VFP tables.
>
>The problem I'm having with a local view is that if user1 modifies a record on the view, and user2 tries to modify the same record, I cannot trap the error instantaneously for user2 (as I would if I were using native base tables). Is there a way to apply the normal base table locking scenarios to local views?
Are you sure it is necessary? In other words, is it likely that two people will edit the same record at the same time?
Chris McCandless
Red Sky Software