Tracking changes made to an address block of info in a database

Ken Doucet doucet at nas.net
Wed Mar 5 04:06:02 PST 2008


I have a need to track changes made to the address part of the database so
that anyone looking at the record can know when the latest changes were made
to an individual's address. In the original DOS database I had added a
change date field and the  block of data in question had a border around it
with a chgedate field embedded in the frame and relied on user to remember
to update that field. This was less than ideal as we could never know how
diligently end users would be in maintaining the field.

I have searched on time stamp and info("fieldname") and modifyrecord - there
is no shortage of material but am I looking in the right area?

Question 1 - is treating a block of data this way viable in
Panorama -perhaps time stamp coupled with .modifyrecord /info(fieldnname)


Thanks,

Ken


More information about the Qna mailing list