>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,
For multiple pages first make classes for pages and init if page is activated and !objectalreadyexist. This would speed up overall form loading. With relation it shouldn't be slow. Are there any set filter (although a set filter in this case is optimizable it's still so slow) ?
Cetin