How could I Track record changes?

[flower88]

Hello,

I'm trying to build a database where I can track changes or revisions made to a quote. The idea is that everytime a quote is made sometimes it needs to be updated so when this happens a letter is assigned to it that indicates the update. For example "A" would be the first entry, "B" would be the second update and so on. Also, I need to be able to print a report using only the latest update for each quote. Any ideas?

Thanks so much

[NeoPa]

What do you want ideas on? What you suggest seems sensible. Are you having any difficulties implementing anything. If so, post a question explaining the the details of each difficulty.

[flower88]

Well, I just wanted ideas on how to get started doing this. I thought about having two tables, one with just the quote number and another with all the information and liking them. But i came to the conclusion that it wasn't gonna work when creating the reports on only the last updated quotes.
Anyway, I'll close this thread.

Thanks tho

[nico5038]

Best approach would probably be to add a TimeStamp to the table and intercept the form's Update and change it into an INSERT. Now using the TimeStamp the last entry can be selected, but all changes (and who did it) can be logged.

Nic;o)