I have a table, in which my PK is a an AutoIncrement Number (Identity). Now I need another field which needs to be 10 Digit & Unique, is there any way i could have 2 auto increment field? I want to avoid generating the number from front end and the passing it.

I would prefere if this could be managed in Back End. Could i use trigger for that sort of thing, or any other ideas?

Thank you.