Re: Keeping history on master/detail tables

Mark, thanks for you reply.

The reason I need to relate the transaction of the header and detail tables is that I have to provide the users with a screen that shows a history of changes to these tables. So if there was a transaction in the past, where the user modified records in both Header and Detail, I want to display it as a single record instead of two separate ones. Otherwise reading the history information will be very confusing.

As for your solution, I think I understand it. But it is still a lot more complicated that I would hope for. Maybe you are right and I need to rethink wether it is really that necessary to have to relate the transactions afterall.

Another method that I am thinking of, which could be simpler, would be to use save date and time of each tranaction in the both header/detail and their history tables. That way, I could group the transactions by their datetime.

Hooman Received on Sun May 21 2006 - 14:45:41 CDT