On 9-12-2013 19:29, checkmail wrote:

> I have change it, now the IDs were created by trigger. Only one
> disadvantage arises, if the user deletes the last recordset and creates
> a new, the last skipped now.

Why is that a disadvantage? Holes in your numbering would also happen if
a user deleted a different recordset (eg the second last) instead of the
last.

Mark
--
Mark Rotteveel