Slow load - I open a main form with a table and, with 1000 records, it loads in a few seconds over the network. Then I open a linked form selecting only some of the records in the child table (relational database) - and it runs a query on the child table with 17000 records but this takes a minute or two. This minute or two of waiting is the problem.
Subsequently when I open another record in the original table and look at the linked form - then it loads in a second.
Any suggestions for speeding this up?
Subsequently when I open another record in the original table and look at the linked form - then it loads in a second.
Any suggestions for speeding this up?
