>Hi,
> I have a table which store the last ID generated for my invoise. It will be access and updated by every user.
>I have a problem that, what type of buffering should be used for this if only this record will be used for ID generation?
> How to re-use the ID if some body cancel the ID before inserted?
>
>Thank you

Others will disagree with this but I use table buffering for all data buffering situations unless there is a compelling reason to use record buffering.

One way to get around the second issue is not to get the new number until the user presses the Save button, then get the new number and inform the user. Others may have more options on this issue.

Bill