Copy data from one table to another?

hlabonte · 2007-02-27T20:08:29+0000

Hi all, I'm using FMP 8 with server Advanced. I have two tables that are mirror copies of each other. I do a SQL call to update table B. Once I'm done, I want take a found set from that table and copy those records to table B. I'm not quite sure of how to accomplish this in FMP. Again the table structure & fields are exactly the same. Any thoughts?