AnsweredAssumed Answered

Lookup solution?

Question asked by ultranix on Dec 10, 2013
Latest reply on Dec 12, 2013 by ultranix

Title

Lookup solution?

Post


     Hey, It seems that when i go further adding summaries and calculations from related tables the database gets heavier and heavier, having 30.000 records itself (and thus navigating between records becomes irritating).

     I wonder is there a way to create separate "no flash-no thrills" database file, where i could store all the calculations with related tables and summaries, and "look up" for data only when it's needed, because for display purposes, i only need 1 record at a time, but sorting, calculating and summarizing all 30.000 in order to make appropriate calculations takes way too much time.

     What could be the solution and is this 2nd database file would speed the process up or another solution is needed?

Outcomes