Search the Community
Showing results for tags 'copy records'.
Found 1 result
Hi, I'm working on a Database that has a lot of calculation and sub-summary. Everything works fine when I'm on the LAN, but when I tried to test it remotely, pulling up a summary report is really really slow because of the Calculation Fields, sorting and sub summary. So, I was thinking and read about creating a Dummy Table to dump all the records from the actual table with the calculation into a Table to store the calculated value as stored text or numbers. However, I'm having difficulty creating a script that will be run every evening. I've tried using an Export and Import, but the field value does not correspond with the original table fields. Whats the best of of doing this? Thanks.