Storing history and displaying to users

I want to keep a running history in my DB that users can view upon query of the recordID. I know it has to be a seperate table, but how do I store it and display it to the user? Any help?

Any help pls!

Are your forms bound or unbound (easier with unbound forms)

What kind of information are you wishing to capture

S-

I am trying to keep track of where a document has been in its life. So when an employee recieves the paper, he/she will enter the system, enter the ID (PK), date recieved, who its going to next, how its going (email, mail...), and any other notes/suggestions. If users need to locate a document at any time they should be able to enter the system, search by ID and find the entire history for the papers life.

I need to keep a running history of where its been in its entirety, cannot overwrite the last users info.

Not sure what you mean by bound & unbound forms. I have forms based on tables (bound fields) and I have forms for searching (unbound fields).

Any suggestions...
Thanks!

For you I would use two tables (unless the documents go through the sames steps each time, everytime).

The first table holds the identification about the document
ID (being PK), Type, Orginator,etc

Second table hold movement information
ID (being PK/FK), date/time sent (being also part of PK) , Sentby, sent to, how, etc

You will then display a query that links these two queries together and use a criteria of the document ID for historical dispaly purposes for user

Give this a try.

S-

Working, Thanks!!! You have been a great help!!