Hi Bret,

In my data environment I have the cursor's buffermodeoverride set to 1, and I have the form's buffermode set to 2. After your response I checked help. Am I right in assuming that this is in fact Row buffereing and I need to change the property on the cursor to 5?

>>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.
>
>Not on table buffering, you are describing row buffering where moving from one record to another saves changes.
>
>
>>
>>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.
>
>Some people create a table of unique keys that will be used by their tables. If you add a record then the key table gets locked a key is generated for you to use and the key table is unlocked, ready for the next person. You use the key in your view and if the view gets saved then you have no problem, if the view is cancelled then all you have lost is that key (not reused in this case). This is only one method in keeping unique keys. It may not be the best way but it can work.
>
>>
>>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