Generating more complicated autonumbers

[connerlowen]

Hi,

I need some help with one thing in my database. I need to generate quotation numbers for the quotes that I will be populating from my database. The process now is simply the format of date-n. The date is in standard format being "05222015" and the n is simply the number quote generated on that given date, For example the first quote generated today would be 05222015-1. I need suggestions on the best way to generate these numbers automatically.

Thanks

 

[pbaldy]

There are some thoughts here:

http://www.baldyweb.com/CustomAutonumber.htm

The DMax() method is very common.