The best practice is to maintain separate audit log.
>
>Is it in best practice to maintain 2 fields in each and every dbf that will record the DATETIME() of the time the record is added and then later edited?
>
>Please advise and any other alternative suggestions.