Rolling Invoice # Automatically

[WTC]

I would like to have my Invoice Number to increase by one every time a new
record is added. I do not want to use the Autonumber feature since it is
tied with the Primary Key. Any ideas?

Thanks

 

[WTC]

I figured it out, using the DMax function.