Forming a reference number for invoice forms???

[Chiana]

Hello!

Could anybody please help me with my problem? I'm developing an invoicing application and I'm trying to form a unique reference number for each invoice from two different variables; customerID and due date. How do I do that?

Thank you in advance!

Chiana

Chiana70@yahoo.com

 

[spencertaylor]

If the customer has more than one invoice due on the same date, this would not be unique. What is wrong with using and autonumber and if you desparately want to you could concatenate the customer id to it if you wanted to. I wouldn't bother storing this value as it could be calculated each time it's needed.