Re: How to save old data

[micromd]

I am a new user.

I have an address database (one table with names & one table with address data). Each time I change the address of a friend, the old address is gone for good. Kindly inform me how I can build a database system so that I can keep a record of the past addresses of each person while the address main table shows the current address of that particular person in FileMaker 7 (i.e. the screen window always shows the current address; but the records of old addresses are saved in another table).

I would appreciate it very much if someone can help in this topic.

[transpower]

Design another table called old_address. Attach a script to a button to copy the address from the current table to the old_address table before updating the current table (use Set Field, etc.). You might want to add a date field to the old_address table to keep track of each record's creation date. You should have a trap to prevent duplicate records from being created.