Hi Oran,

<quote>
How would it look if I was actually updating a record?
Would the ValidTo get the current date and a new record is created
with ValidTo being NULL?
</quote>

That is exactly right Your Create* columns show you who made the
change (insert/update/delete's are all just changes to the current
state of your data), and the Valid* columns reflect the time period
for which the row was "current". So for an update, you simply
timestamp the ValidTo column in the old "current" row and insert a new
row with a NULL ValidTo column.

<quote>
So it would sound like the tbl_EventLog would be classified as a
"Log"
table. I don't have any history tables with data of what happened at
a
certain point in time.
</quote>

It does sound like EventLog is a true "log", but I would probably keep
full history on the Folder table.

<quote>
>> I guess this is a document management system but it is for physical folders not files on a computer. <<

PAPER!? They still make that stuff?
</quote>

Hehe - Celko has a sense of humor?!?

Good luck!
J