Hi All,

I am looking in to creating a Log database. I want it to log the activity of one of my dbs.

before i start i was wondering if anyone has done this before and has and advice that they can give me.

i have a few ideas but many brains is better than 1!!

the db that i want to log is a tracking system so many happenings can happen on one record.

i think i will use a relationship to input info in the log db using a unique id field from the tracking system.

For those of you who have log dbs what info do you input into your log dbs

thanks in advance amd Merry Christmas.

ricardo.

Do you mean an audit trail of all the changes made to your tracking db?

If so, look in the Sample Files for the Starter Template that I posted (grab the attachment further down in the thread). That template is designed to log all the changes in the various DB's into the one log DB.

HTH.