Producing a Tracking Number

[cmefly]

Hi,

I hope someone can assist me with this.

I've produced a simple purchase order form in MS Access but am having trouble producing the tracking number. Here is the situation.
The purchase order form is a single file found on our shared server. This means that anyone in the purchasing department can open the file at anytime, file out the form, and send it off....Now, the thing is, i don't want staff saving the file.....I just want them to open it, use it, and close it....how do I make certain that tracking numbers are not duplicated and go in a sequential order (ie: 1001, 1002, 1003, 1004.....etc.) everytime some else opens it???

Any help would be greatly appreciated.

Thank You,

cmefly

 

[Andrew Fergus]

Hi, is there a table supporting the form? Or is it just a form with a number of unbound controls? If there is a table, what fields have you set up in the table? And if there is no table, a unique id would a combination of the date and time (assuming 2 users don't create an order at exactly the same second) e.g. yymmddhhss (but built using now, year, month etc. functions and a few "&"s in between).

Andrew