Hi,

Why not use solution similar to following:

How to create an audit trail of record changes in a form in Access 2000
http://support.microsoft.com/?kbid=197592

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or
to visit Windows Update at http://windowsupdate.microsoft.com/ to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Thread-Topic: Keeping Track of Revisions
| thread-index: AcSbVzHBtxTVYozjSzC0N1pLfW5Pvg==
| X-WBNR-Posting-Host: 192.169.41.40
| From: "=?Utf-8?B?Q0s=?="
| Subject: Keeping Track of Revisions
| Date: Wed, 15 Sep 2004 12:07:07 -0700
| Lines: 10
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.tablesdbdesign
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:83960
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| I have 2 tables that are linked: Proforma Invoice and Items Ordered. For
one
| Proforma Invoice, there could be many items ordered. The challenge is
that I
| need to maintain some kind of revision when any of those information are
| changed like additional items, change in color, change in delivery dates,
etc
| and they could be in any of those 2 tables.
|
| Is there any way I can do a "snapshot" of the data and store that into
| another table since changing the values in the fields means overwriting
the
| previous info? Or is anyone able to suggest a better way? Thanks.
| ck
|