Is there a easy way to implement sequential numbering for records?
What I need is:
on a table i have a string field, let's say seqId
and in every form I would like to initialise the field with the next number in in the sequence, but as the same time format it like INV-000001, INV-000002 etc.
It should be DB independent :)
Thanks in advance