>I want to update multiple records in local views by reusing deleted records when possible. I have tried deleting all records in my local view based on its requery of the base table, recalling a record as it is needed for updating the base table, and updating with a replace. When I attempt this I get an error message stating that I have a attempted to add a duplicate primary key. During debug it appears the view record is not updating the same record in the base table, but this doesn't make sense to me, since the primary key in the view should identify the proper record to recall and update.
>
>If you are confused by my description of the problem, your techniques for updating multiple records from a local view with the reuse of deleted records would be very helpful I'm sure.
>
>I certainly appreciate your help.
>
>Thanks in advance.
Add a filter to you primary key index "NOT DELETED()".