how can i link 2 tables

[bradshawc]

I want to create a duplicate table, like a history table. I have one table that is accessed by a ASP script, i want anything that is added to the table to automaticaly be added to another, but not deleted.

 

[nealvenables]

Unfortunately (unless someone out there knows a trick that I'm not aware of) all you can do is rewrite your application so that every procedure that inserts data into your main table also inserts the same data into your history table.

However, if you ever upgrade your database to SQL, you can do this automatically at the table level via an Insert Trigger.

Good luck.

 

[JeremyNYC]

MichaelRed has some code to keep a history of your application. I haven't used, and he's mentioned a limitation or two of it, but it looks quite good. Find him here and I think you'll find it in one of his FAQs.

Jeremy ==
Jeremy Wallace
AlphaBet City Dataworks

http://www.AlphaBetCityDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.