In my product database, I need to keep track of when pricing fields are changed. I have set up a field that shows the record modification date, but I really don't need it to change when any of the other field were changed.

Is there a way that I can get the modification date for just one field on a layout?

Version: v6.x

Platform: Windows XP

It's a workaround, but put the field you want to track in a separate, related database/table. In other words, set up a table with fields for the part ID and price. (Say, PartPriceDB.) Relate it to the database with the part ID, name, etc. via the part ID field. (Say, PartInfoDB.) Now, you can track modifications to the PartPriceDB records, which will be unaffected by changes to the PartInfoDB records.

Version: v7.x

Platform: Mac OS X Panther

Hi,

Try for example :

Case(YourPriceField1, DateToText(Status(CurrentDate))&"-"&TimeToText(Status(CurrentTime)), DateToText(Status(CurrentDate))&"-"&TimeToText(Status(CurrentTime)))

If there are several fields (this wasn't clear in your post), try Case(YourPriceField1&YourPriceField2&YourPriceField3,...

If I can do this for 2 field it would be great, but even just for one would be beter than nothing. I'll give these suggestions a try.

Thanks for your help,

Elizabeth