>>I have this one table that I'm having problems with when trying to recall deleted records and I'm completely stumped as to what is going on.
>>
>>In my test data, this table has 6 records, 3 of them being deleted. If I attempt a RECALL ALL, only one of the records is undeleted. If I RECALL ALL again, then the second deleted record undeletes. As far as I can see, this seems to be happening only on one table. I ran FoxFix on the table and didn't run into any errors. Could someone shed light onto what might contribute to this weird behavior?
>
>How do you know that only one record has been recalled?

Because when I browse the table after the recall, that's exactly what appears to have happened. In the interim, I've been able to determine that the insert trigger is what's causing the issue.

That said, I'm not clear yet as to why the trigger could be limiting the recall to one record.