Retaining *history*

[pakiyabhai]

My firm is primarily an export firm and I am looking forward to design a simple database wherein I would have the buyer's order number as the primary key and everyday simple changes would be made as per the progress done.

I wanna know is it possible to have a history of changes done on a particular record..

for example i have fileds

Buyer PO number

Buyer PO date

Buyer Test Date

now if I make a change to buyer test date ,suppose it was 4th of June,08 and I change that to 8th of June,08 , I want this change to be recorded maybe reflected somewhere.

[mr_vodka]

See here...

Audit Trail Links

[aldipalo]

The simple answer is to set up a modification date field or Time Stamp field. Then anytime there is a change to the record the field is automatically stamped with the date/timestamp.

[Fitch]

That does track record modification, Al. But field-level tracking would require some sort of audit trail technique (nice list, John).

[aldipalo]

Yep, as I said, just a simple answer. I let you really knowledgeable guys come up with the more complex answers. Personally, I've never used an Audit Trail, so wouldn't have thought of it.

'My Bad.'

[Fitch]

I hope I didn't sound like I was being dismissive of your answer. Simple answers are my favorite kind!

As I read the question again though, the OP is apparently looking for not only the last modified date of particular fields, but a history of modifications. That is an audit trail in a nutshell.

[aldipalo]

I agree and I didn't take offense nor was I trying to be defensive with my response. I always bow to you folks who have much more experience than I.

As I reread it I came to same conclusion. I was interrupted while I was answering it and when I came back I just clicked 'ADD.' Usually, I reread the posting before submitting an answer. So, 'My Bad.'

:)