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.