How to generate reference number?

harnisa

New Member
Hi,
I need auto-incremented numbers for example starting from C-0001. Is it possible?

For example, when I want to add new, the new auto reference number show in the reference field.

Kindly please advise.

Thank you.

Harnisa
 
It's easy to do one that gets created after the form has been submitted, using the table's PK as the number to base it on.

Making one that displays when you open a new form is not so easy, because the PK is not assigned until after the form is submitted (and the row in the table is actually created).

Is it critical that you display the number when adding the new form?

-- hugh
 
We are in need of some funding.
More details.

Thank you.

Members online

No members online now.
Back
Top