AnsweredAssumed Answered

Move record from one table to another

Question asked by robdownunder on Mar 22, 2012
Latest reply on Mar 22, 2012 by robdownunder


Move record from one table to another


I have a table of events, which are a kind of 'to do' item. I'm finding that acessing the table via ipad or iphone apps is slow due to the large numbers of completed events in this table. On the mac there is no slowdown, but the ipad (2 and 3) it can be glacial.

So rather than have a field for completed  events I thought I'd move the completed events to a separate archive table. The completed events are never needed for day to day queries.

What's the best way to move a record from one table to another?