Using a Repeating Field to store Modifier Name

[DaveC]

Hi,

I'd like to use a field to store Modifier name, keeping a list of the last 5 users who have changed a record. I have tried to use a repeating field, but cant figure out how to move the entries along - ie from one repeating field box to the next - each time a new modification is mode. At the moment, each time a Modifier Name is changed, it overwrites the first entry in the repeating field.

Any help on this - including if there is a better approach to keep a history of who changed a record - gratefully received.

Dave

Version: v6.x

Platform: Windows 95/98

[Lee Smith]

Hi Dave,

I have looked at several Audit or Field Modification trackers and I can't remember any that use Repeating Fields. You probably already know about these files, but this is a list of the files that I have looked at. Perhaps one of these will fit your needs better.

Field Modification Tracker By: Bob Cusick URL:

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

Modification Times By: Alberto Diaz-Hermidas URL:

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

Tracking Modifications By: Steve Wilmes URL:

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

Field Modification By: John Mark Osborne URL:

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

Modification Log By: John Mark Osborne URL:

http://www.databasepros.com

Modify By: Hedrich Michaelsen URL:

http://www.databasepros.com

Audit History of Fields By: Rick Knight URL:

http://www.fmforums.com

Comprehensive Audit Tracking System By: Ray J. Cologon URL:

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

HTH

Lee

[Ugo DI LUCA]

Hi,

Why would you like to store this data in Repeating Fields ?

You may play with some Insert Repeat trick (check the Sample Section) so that to update your list as needed.