Are you appending changes to text already logged in the field?
If so, define a related table where you can log changes in a new record in this table each time a field is modified.
Yes I am appending all field changes to a log field.
If so, define a related table where you can log changes in a new record in this table each time a field is modified
I'm not too sure what you mean here. Could you please elaborate?
The details can vary a lot.
Here's just the broad outline:
Set Variable [$ID ; YourTable::YourPrimaryKey ]
//You can capture data from other fields in your current record if you need to
go To Layout [//select layout to log table]
Set Field [LogTable::IDfield ; $ID ]
// log any additional data such as account and/or user names here
// looked up value field options can be defined in the log tabl to copy data from selected fields in the original table if you want
Go To Layout [Original Layout]
Ray Cologon, the author of SuperLog, has an upgrade called UltraLog. In it he has a method of archiving the log field data to a separate table, which can be made as a separate file. This allows you to periodically clear out the LogData field in the main file and will keep the size down.
I have three good suggestions here each with pros and cons. I need to give all a little more analysis.
I'll let you know the outcome
One last possibility: plug-ins. CNS makes one and I believe WorldSync has one. They do all the heavy lifting and depending on the value of your time may be a quicker, easier way to go.