Creating Update/Last Saved Field for Records

[CanadianTeabone]

I am wondering if I can create a field, that will show when a record has been created/updated with information. the =date() expression just shows the current date on the system, is there and way to do this?

 

[CanadianTeabone]

I am wondering If I should have a field for update and one for creation, to track the records creation date, and then one for the updates to the record. Anybody follow?

 

[Darrylles]

Hi,

You answered your own question.

You need a 'Creation' field within the table to show creation date.

For update records, you should use another table because there may be MANY updates to the original record.

e.g.

tblMain
pk autonumber
creationdate datetime
(other fields)

tblUpdates
pk autonumber
myupdate datetime
tblMain_fk long (link to tblMain PK)

So you create a relationship between tblMain and tblUpdates of 1:many.

If you want to know WHEN an update has occurred, you probably want to know WHAT has been changed. In this case you'll need more fields in tblUpdates to show the changes.

Regards,

Darrylle
"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[CanadianTeabone]

So does that new table I make have to mirror all the feilds that are in my primary table? Is there some sort of VBA code involved with having the save1d/updated date in a feild?

Ps - Thankx for you help