Hello,

I know that this is maybe a simple task, but I didn't find the clou...

We need a simple history/versioning support for a customer, so that every change to an object is always an "insert" with a different version number and timestamp. The foreign keys are a composite from ID and max(timestamp) . E.g.

Parent
------------------
ID,version, timstamp

1, 1, 1.1.2004
1, 2, 2.1.2004
1, 3, 3.1.2004
2, 1, 4.2.2004
2, 2, 5.2.2004

The childrens foreign key is the ID and max of timestamp.

Is there a fast and easy "build in" solution or any other idea ?

Thanks...

Stefan

A view