newbie Q - Can filemaker Pro 11 keep track of changes in a field?
I am a newbie to filemaker pro (and to databases in general) but I'd consider myself an advanced computer user. I have filemaker pro 11 on a windows 7 (64bit) machine. This is a database just for myself (I am a scientist with lots of data that I think is suitable for a relational database), so it is not network shared or anything like that.
So my question is, can filemaker pro keep track of changes in fields?
(this is an example, my data is quite different., but I think the point is the same).
For example, say I have a record with three fields: name, address, zip
Jason, 1234 woohoo lane, 12345
What if the person changes address?
Jason, 9876 banana drive, 54321
I would update the record with a new address and zip ... but I'd like filemaker to keep a record of the previous address.
In essence, I want to be able to search for Jason and see his new address as well as his old one(s).
Is this possible?