> Yes, but my real questions was, is creating and deleting records in this persistent table more better way, or creating and dropping lots of persistent tables as and when the report is run.

Because you are using FoxPro, it would be better to use it's own data
storage capacity to keep temporary data and don't put them into main
database.

SY, SD.