I have a form with a grid and bound text boxes based on a view. I have optimistic table buffering enabled. The functionality I desire is to let them key in multiple records and then be able to hit save to save all of the records or cancel to revert all the records.

My problem is that I have candidate indexes on the base table so when a record is added to the view I want to make sure it hasn't already been entered.

If I understand it correctly...If I move the record pointer in the base table the record is committed and can't be reverted with the cancel button.

So I've tried using the base table again in another work area but that doesn't seem to contain the current records added to the view. I've also tried using indexseek() but this doesn't seem to find the records not committed either.

The only way I can find a record is if I search the base table which works fine until I hit cancel to revert the records they don't all get reverted.

Another problem I think I am going to run into is that I will need to requery these views in certain cases prior to hitting the save or cancel. It seems that this is causing me the same grief.

Is there any way to get the functionality I desire.

TIA,
Paul