Interview Question in Sharepoint 2007


 

Question :: How to generate an auto number in Microsoft Sharepoint 2007

I'm working on a help desk site for my company and we need a way for it to generate ticket numbers for service requests. We've tried to create a calculation column and have it set to =ID. It works at first but then if you edit any entry, the ID becomes 0. So how exactly can you generate consecutive numbers with sharepoint 2007 and not have the number change? Thanks.