>Thanks,
>
>Both of your ideas worked perfectly, I do have 1 more problem to get over,
>
>I need a simple (hopefully) way to truly move records from 1 table to another within the .dbc, however the part where it gets tricky for me is I need the table that the data is being moved from to be minus that record and the table where the data is updated to to have the new record added (all records are unique via lot# auto integer).
>
>Without using a lot of code with copy to delete and pack/zap every now and again I don't know another way.
>
>Any ideas?
>
>
>Thanks
>
>Fred W.

Hi Fred,

What is the criteria you're using to move records?

Basically, you can use the same criteria in both Insert and delete SQL commands, as

insert into MyNewTable select * from myOldTable where ...

delete from myOldTable where ...

I need more details from you to get the exact commands right, but hopefully this idea can get you started.