Unique reference number

30 pts.
Tags:
References
Hello, I have built a quote calculator for a client of mine. However, for some reason I'm completely stumped when trying to generate a unique reference number. I need a new number to appear in the reference cell each and every time the sheet is reopened. I have a button for the client to click confirming their order, which is emailed directly to me. Without the ref it becomes difficult to determine which order is for which job, I only have the date to go by. Any help would be greatly appreciated. If you need me to explain further please let me know. Many thanks,
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • CharlieBrowne
    What DataBase and Language are you using?
    With most databases, you can set up a auto generated field. So then you write the record and then retrieve the unique number to display.
    62,385 pointsBadges:
    report
  • Subhendu Sen
    Please provide the actual scenario like environment/ OS/ applications or any other helpful information, that can help us to provide some good replies.
    139,200 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: