This is a continuation of a previous thread but also a new concept:

Thread Link

Basically because the Audit field can only hold 64,000 chars (not that I expect that my audit to every get that big but nice to have it setup so that it doesn't need to be thought about) and due to the fact that I saw this rather cool demo from who else but Ray @ http://www.nightwing.com.au/FileMaker:

The Rolling Log

What I want to achieve is an audit log which captures the last 250 entries and deletes the old one (Rolling).

What I was trying was basically having the audit trigger produce 1 line each time and that then gets added to the Name.log (field in rolling log) which would be the cell containing the 250 entries.... problem is that I can't get the trigger to triger both actions.

Attached is both file. Any one has any knowledge of this please let me know.

Thanks

New_Problem.zip

Simon,

There is a rather easier way to approach this - simply collapse the two processes into one.

See attached example.

AuditRoller.zip

Magic!