Having an issue with the time it takes to open layouts and add data to table. Here is the current setup:
Table 1::Production Data This table has information related to our printing process where I summarize time, material, waste by various sub groups and grand totals. Everything works perfectly here, but the calculation fields are causing some issues when getting into the layout and entering data into the layout. My issue is that I have roughly 3000 records in the table in a short time span and the summary/grand total fields seem to recalculate in particular when entering the layout/table for the first time. I will have many thousands of records by years end. It literally takes around 2 minutes on initial entry, and the same recalculation can occur when one enters/changes a record. Data is entered into the table via iPad from various parts of the production process and this recalculation seems to be popping up slowing the process down.
The summary fields are used to create production reports for press, shift and job by week, day, year, year2date and any financial period in the current fiscal year.
#1 Is there a means of controlling when summary fields calculate? I cannot find one...
#2 I have thought about creating two tables: Table 1 :: Production data and Table 2:: Production data Report, using script to export the found set from the table 1 to table 2. I would move the summary fields from table 1 into table 2. This would allow me to keep the summary fields from calculating until I had the specific set of data required for reporting in table 2. Thinking this should eliminate the calculations in table 1 and eliminate the time required to enter data.
Table 1 Layout
export found set into table 2
perform reports (calculations have minimal data to summarize)
delete all records from table 2
return to table 1 layout
Is there a simple way to export data from one table to another in the same file? Currently I would export table 1 data to desktop and import into table 2?? Is there a way to just go from table 1 directly to table 2?