> One question:
>
> How do I decrement the value of the Generator (without setting it) if
> I have tried to make a new person, but decided to cancel the idea.
> Therefore, when I press the 'Cancel' button on a form, it will
> decrement the Generator value?
>
> Thanks heaps!
>
> Gaurav

maybe you have another idea...
think about this case.....
20 people all working happily on your system
ID=1
user A makes "a new person",
ID=2
then user D makes "a new person",
ID=3
and commits
then user A decides to cancel
ID=2
user C comes along and makes "a new person"
ID=3
and tries to commit - bang - Db screams at you and slaps your face for
trying to make two records with ID=3

Alan