• Registered: 2016-07-28
  • Posts: 1,033

Topic: Creating unique auto incrementing field?

Hi Guys,


How can I create an unique auto incrementing field with text before (prefix) option?
Something similar to tGrid auto increment.
I like to use for numbering invoices, products, customers etc., such as INV 123 or INV-123 rather than just 123 which can be done with record count. Unfortunately, record count doesn't have prefix option or I'm missing it.

Adam
God... please help me become the person my dog thinks I am.
  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,678

Re: Creating unique auto incrementing field?

Hello Adam,
As always with MVD, different ways to do it - this is probably one of the simpler options (which is why I like it - LOL!!).
Regards,
Derek.

Post's attachments

Attachment icon adamnumbers.zip 337.12 kb, 493 downloads since 2016-12-23 

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Creating unique auto incrementing field?

Hello.


An example:
http://myvisualdatabase.com/forum/misc. … download=1

Dmitry.
  • Registered: 2016-07-28
  • Posts: 1,033

Re: Creating unique auto incrementing field?

Thanks a lot Guys..........

Adam
God... please help me become the person my dog thinks I am.