Question about insert

[Zaonpt]

Hi guys,
I have a problem that I'm struggling to solve.
I have two tables (link and linkhistory, example) that are essentially the same although when something is deleted ill remove only from the table link. this way I keep an history of old links on the other table and only the active links on the 1st one.


I thought about merging this two and have a boolean field "active" but i feel that splitting the two concepts will make my life easier (maybe not).

So my question is:
Is there a way of when something is inserted in table link that will be automatic (via trigger or some access automatism) make the same insert in the linkhistory table.

Notes:
I know this approach violates all Database development rules, I am not sure yet will go with this, I'm just wondering if this is viable technically.

TY

[June7]

Yes, it is technically viable and by more than one method. Here is one way to deal with http://allenbrowne.com/AppAudit.html

[orange]

I would go with the "activeFlag" boolean, but you may get some ideas from this thread re Data macros.
I posted an example using a table data macro and named data macros to create an Audit log in post 21 in that thread.

Good luck.

[isladogs]

Just because something is technically viable, doesn't mean it's a good idea

Instead, I would also support the idea of a boolean field Active.
This means you would never delete existing records & do not need a second almost identical table

However, I would also recommend you create backup copies of the entire database on a regular basis e.g. daily?

[Zaonpt]

TY all for the replies, i also think its better to use the boolean, its the current state my DB, its probably not gonna change.