Reference Number... pls help!!!

[garfield11]

Hi.

I need to create a quotation but I have some problen with the ref num. I want the ref num to be display as for e.g. Q/001/02. Q stands for quotation. 001 is the ID and I want it to be like everytime a new user opens a new quotation, the ID will increase by 1. 02 is the year e.g. year 2002 and if it reaches year 2003 i want it to automatically change to 03. So is there any way to do it?

Thanks!

Love_Garfield =)

 

[dianal]

Hello,
Your task could be better solved with server side using a database.
If you do not have database it will be usefull to have a file to write to at server side.
If it is only client side it will be very difficult to achieve the result you want.
Please specify your problem.