Briefly, I double-click on a key field in the first View that is linked to a second View. The second View is using the table: “GL Transactions w/Master, Dept (RO)”.
The link and the Workspace is working.

Every time we lookup the data that we are searching for, it takes about 25 seconds on my laptop to refresh (and longer at the client).
There are about 600,000 detail records in the second GV file and growing.

Any recommendations to speed this up?