Something like:
scatter name loRecord
delete
select (other table)
append blank
gather name loRecord
If you have triggers, this will require buffering in table 2. Also, you should put everything within a transaction.
>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)