I currently have a form with a pageframe with multiple pages. Each page contains a grid from a different related file. The user views one account at a time, with each page showing the related information for that account (i.e. - one page shows addresses, another phones, etc.) This form takes a very long time to load and I want to know how I can speed it up. Right now I have all of the tables in the data environment of the form with relations set up in the data environment. As the user navigates between accounts, the grids refresh with the related information. Is there a better way of handling the data? Would it be faster to use (parameterized?) views? How can I make the form load faster? Any suggestions greatly appreciated!
Thanks,
Elyse
Elyse Pomerantz