>Look at the Primary Key article on my web site. It works for PKs, but if you must have sequential numbers, you are going to have problems. What happens if someone cancels the Add or deletes a record? You'll be missing a number. IMO, don't assign the number until the user actually saves the record.
Actually this is the workaround I have implemented in this kind of case. And it works fine.
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain