>I agree with Erik, after a couple of thousand appointment deletions, there's going to be a lot of I/O.
>
>There's a buzillion ways to approach this so here's my 2 cents.
>
>How about before you delete the record, you save it in the backup table? With Appointments selected and the record pointer on the record you're about to delete ...
>
> scatter memvar memo
> insert into backup2 from memvar
>
>... then go ahead and delete the appointment record you wanted to in the firstplace.
>
>Are you also going to want to recall appointments? If so, you could do the reverse from BackUp and insert into appointments, although you may have to monkey with any primary keys.
>
>HTH,
I do backup to the table.Sometimes a user deletes maany appointmennts and its a nice touch if he sees a message box showing him how many he has inserted into the backup table.
Thanks all the same
Zaraq
Teachers open the door, but you must enter by yourself.