Adding a single record to another table with auto number

[Elie00]

Hello,

Here's my case: i have to issue a document that has 2 auto numbers:
One upon creation of the file and the other upon printing.

My initial idea was to create 2 tables, the first contains the "creation" auto number, when i'm ready to print i use an append query to send it to the second table and the second auto number will be assigned automatically.

The thing is that the "creation" auto number and the "printing" auto number won't be at the same order, for example: i might have 3 files, but might print file Number 3 before number 2 and so on and so forth.

Query Append and query update won't work and will give me errors

i really hope someone can give me a constructive idea on how to do it!

Elie.

 

[G37Sam]

Why not just record printing Date & Time?

 

[Elie00]

i'm bound to have a printing auto number, cause it has to be in a certain format.

actually i don't need a "creation" auto number, i can input it manually.

i can always use the initial table to fill in one record at a time and add it to the printing table, but i'll have a problem if i'm working on more than one file at a time it will append all of them at the same time instead of just the one i want to print.