Hi need to create a table.
I want 5 Five Fields
Reg ID -- Auto Number.
First Name - Text
Last Name - Text
email - Text
Phone - Number
Which i have done it.
I have problem in "Reg ID" Field. I need ID to be in this format("A0001")
But i am not able to get that . Instead i am getting 1,2,3,4 to etc.
but i need the Reg ID Field to be Auto generated in Incremental order.
A0001
A0002
A0003
A0004
A0005 etc
Kindly help.
Advance in Thanks
I want 5 Five Fields
Reg ID -- Auto Number.
First Name - Text
Last Name - Text
email - Text
Phone - Number
Which i have done it.
I have problem in "Reg ID" Field. I need ID to be in this format("A0001")
But i am not able to get that . Instead i am getting 1,2,3,4 to etc.
but i need the Reg ID Field to be Auto generated in Incremental order.
A0001
A0002
A0003
A0004
A0005 etc
Kindly help.
Advance in Thanks