Tracking system

[Dusty_Rods]

Hello everyone,

Hope everyone is well?.

So im developing a db for a client who want to be able to track who does what to what record so at the end of every table i have a calculation called tracking with the following code...

tracking & "," & Get ( AccountName ) & "*" & Get ( CurrentDate ) & "*" & Get ( CurrentTime )

I put tracking first so that if someone comes along at a later date it gets added to tracking and doesnt replace it the , seperates the occurances of a change and the * seperate the name date and time. So my question is ...

Is there a better way of doing this as i am having difficult getting even this to work also which is the best way to show this data to the client can a portal sort comma delimeted fields? or is there something better i can use...

Any help would be very much appriated

thanks for reading,

D

[Lee Smith]

Hi D, and Welcome to the Forum.

Not sure if anyone has developed an "Audit" or "Field Modification" demo file for v7 yet, but this need has been discussed several times in the past.

Do a search of all forums for " audit " (using quotes with the spaces as shown, and you will get an abundance of reading material.

Here are a couple of links that have demo files in fp5 format.

File by CobaltSky

File by Ugo DI LUCA

Here are a couple of others that may be helpful to you also:

Field Modification By: John Mark Osborne URL:

http://www.fmfiles.com/tnt4.html

Modification Log By: John Mark Osborne URL:

http://www.databasepros.com/resources.html

Tracking Modifications By: Steve Wilmes

Field Modification Tracker By: Bob Cusick

Modification Times By: Alberto Diaz-Hermidas

[Dusty_Rods]

lee thats great thanks very much your a *

D

[Fenton]

CobaltSky (Ray Cologon) has the same audit file, updated and optimized for 7. I couldn't find it here, but it's at his web site (along with other great files; look at the 747 pack):

http://www.nightwing.com.au/FileMaker