Updating one table with another

[talat.riaz]

Hi All,

Here's the scenario :

Table 1 : Each record has unique id
Table 2: Every time a record in Table 1 is created and/or updated
table2 stores each as a seperate record

Each time a record is added / updated a copy of the new updated record
is added to another table (this table essentially stores all the
changes to a record, it keeps the change history of a record). I want
to track all changes to records in this second table so that I can
track the change history.

I hope that is clear.

Any suggestions greatly appreciated.

Thanks in advance.

T.

['69 Camaro]

Hi.

I hope that is clear.

Crystal.

Any suggestions greatly appreciated.

Don't use Jet for this. Instead, use a server database that supports
triggers. The trigger can execute whenever a record in Table 1 is updated
or a record is inserted, and put a new record in Table 2. Links to free
server databases from the major database vendors, such as Oracle, Microsoft,
and IBM, can be found on the following Web site:

http://www.backends.QBuilt.com/

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
<ta********@gmail.comwrote in message
news:11*********************@j27g2000cwj.googlegro ups.com...

Hi All,

Here's the scenario :

Table 1 : Each record has unique id
Table 2: Every time a record in Table 1 is created and/or updated
table2 stores each as a seperate record

Each time a record is added / updated a copy of the new updated record
is added to another table (this table essentially stores all the
changes to a record, it keeps the change history of a record). I want
to track all changes to records in this second table so that I can
track the change history.

I hope that is clear.

Any suggestions greatly appreciated.

Thanks in advance.

T.