Modification Date for Individual Fields
Is it possible within FileMaker Pro to set a modification date field that is only associated with a certain field?
I have database that is used to record a bank of exam questions and which I use to produce exam papers as required, each question occupying a single record. Currently, I have a Date Modified field which tells me when the record as a whole was last modified but shows when ANY field on the database is modified as when, for instance, I select a question for inclusion in an exam paper and enter the exam date against the question. Effectively, this overrides the date on which I may have updated a question at some point in the past.
Ideally, I would like to have a series of dates, each associated with just one of the three or four critical fields on the database, e.g. the question and its expected answer, that would change only if the associated field was changed.