sign the data updated

[patatrac]

Hi for all
is possible track the updated data on colum of the table and made a report that show me what's is update on column.
Thanks

 

[Privateer]

patatrac, it is. One option would be to include the date and time the update was made and use this to filter a report. When I add a new record I have a column called TransLog formated as general date and I use now() to get the date and time in there. Whenever the record is changed you update the field with the new date and time. Some people use three fields, created, previousmodified and lastmodified, and if you include an ID to track the person, that makes it six columns. Hope this helps
Cheers,
Privateer

 

[patatrac]

thank I think this is the way most better for track the modify.