How to display latest fields updates yet saving all changes for viewing later?

[tottijohn]

Hi, i am encountering a problem here i cant solve... :

Take for example person A added a new record1 into table1, person B is able to view all records via table1. If A is to edit any fields of record1, is there a way whereby any changes are saved for viewing later while only displaying the latest changes to person B? Not sure whether i am making any sense here...

Something like this. Person A new record in the table:

x1 y1 z1

After editing:

x1 y1 z1

x1 y2 z2

B can only see x1 y2 z2 but i want to be able to save both. The records consist of many fields so if possible any updates can be only specific to the field and not just adding a whole new records, thanks

[Lee Smith]

It sounds like you need an Audit File or Field Modification Tracking system.

If so, take a look at [color:blue]SuperLog Audit System !! Here

Lee

[tottijohn]

Thanks for the reply!

Anyway right now i am trying to use LAST to display only the last modified fields. I am trying to create two tables with with the same fields, one to add and modify records, the 2nd one to display only the latest modification records, but i cant get the 2nd one to automatically display records that are input into the 1st table......

Was thinking of just using one table, and a portal to display the lastest records, but it aint working out. Any input here is welcome.