>I want to make a copy of a record in a table and add it to the same table. I know that I can set carry on and just use the append command to do this but it opens the edit window. The only way to append without opening the edit window that I know of is to use append blank but then I have to use replace commands to fill the blank fields. How can I append without opening the edit window?
>
>Thanks in advance,
>Justin

select mytable
scatter memvar memo
insert into myTable from memvar

Beware with PKs.
Cetin