Hi,
My database needs to show an audit trail of who nominates a contact and cancels a contact (these functions managed by separate Nominate and Cancel forms), person who initiated, date and time. I have done similar things before using a table and unhiding rows when various actions happen, but it is cumbersome to maintain, and not very efficient. Plus you are never sure whether the row limit in the design will be reached.
There must be better approaches surely? One thing I thought of is to dynamically add (create) rows when needed. But for the information I want to record, a table with separate fields still seems like too much.
Someone else here suggested using a Rich Text field. Could anyone explain how this would work, e.g. what functions / LS methods I would use to manipulate the field, or point me in the right direction?
If it matters, the rich text field would be on a different form to the one being used (e.g. the Nominate or Cancel form would need to manipulate the RT field on the Main form).
Many thanks,
Steve