By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,516 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,516 IT Pros & Developers. It's quick & easy.

How could I Track record changes?

P: 22
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
Jul 9 '10 #1

✓ answered by 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)

Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,768
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.
Jul 9 '10 #2

P: 22
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
Jul 9 '10 #3

nico5038
Expert 2.5K+
P: 3,072
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)
Jul 9 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.