Hi All,

Here's the situation: I have a row buffered master table, showing the description and applicable dates of a business process. I have a view, optimistically table buffered, of steps in the process. Each step may have none, one, or more forms that have to be printed. I am storing this in a view. This, too, is optimistically table buffered.

Let's call these tables: Process, lvProcSteps, and lvStepForms

My problem is this: While I lock in the current Process record when an edit has begun, the user could jump between lcProcSteps records, rearranging them adding detail, and whatnot. Not a problem, as it's table buffered and I can revert or update all changes. My problem is with the lvStepForms view. If the record pointer is moved in lvProcSteps, I have to REQUERY lvStepForms. If I do that, I must save or revert changes to lvStepForms. If I save changes during the edit in lvStepForms, and then Revert the overall edit, it's only going to revert changes to lvStepForms since the last change of record in lvProcSteps during the edit. There could be orphans; or otherwise unexpected data

What to do? Any suggestions? I have ways to resolve this involving orphan checking, change tables, etc. but they're all sloppy.