Joined: 09 Nov 2010
Online Status: Offline
Posts: 36
Topic: Assign Unique Record Number? Posted: 09 Nov 2010 at 6:10am
Hi,
I was curious to know if there was any way to assign a unqiue record number to a report that will not be repeated again. (ex. Invoice#, PO#, etc).
My goal was to create a receiving report for our company with a unique "receiver" number assigned everytime we receive some item in to stock. This "receiver number" cannot be repeated for another receipt, so it must be unique.
Joined: 09 Nov 2010
Online Status: Offline
Posts: 2
Posted: 09 Nov 2010 at 8:46am
Hi,
Typically your database would store that value, and your application or database would create it, and the report would just print the value that is stored in the database. That way, if you need to reprint the invoice, it still has the original number.
Perhaps you could use a combination of the date + Time + milliseconds to get a pseudo-unique number.
Joined: 09 Nov 2010
Online Status: Offline
Posts: 36
Posted: 10 Nov 2010 at 2:18am
Thanks Quinton.
The problem is that our database/application does not have this particular report. i wanted to create this from scratch. But you suggestion of Date+time+millisecond seems to be logical.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged