Keep deleted and edited records in separate table

[Guru Salem]

I need to keep the deleted and edited records in separate table

could you please anyone give me the steps to implement this feature to my FileMaker database.

Many thanks in advance for your help.

[Bailey Kessing]

I am not sure if this will help, but I have been looking at: http://www.syncdek.com/fmdataguard/faq.html

[LaRetta]

Hi Gurusamy,

Usually it is suggested to keep deletes in the table and simply flag them. Moving them to a deletion table can involvie moving their children to THEIR deletion table. Can you explain the type of data and situation here? Moving records should be avoided but I suppose there can be exceptions. For instance, one company had 12 years of data and finally archived the older two years, deciding to archive a year off, every year to keep it at 10.

Depending upon the data you want to delete (for example if it is a customer), and you delete the customers orders as well (which you would need to do or you have orphans), you have just decreased the bottom line sales for that year which throws the books askew. You also lose possibility of data modeling which is quite powerful.

As for keeping edited records in another table, an audit trail process, such as Bailey suggests is better approach. DataGuard is incredible and even allows roll-backs but there are others including Ray's great Ultra-Log http://www.nightwing...sX/demoX01.html.