table relationship sorting help
Some of my users are traveling overseas and finding our database loads very slowly. The majority of the loading time appears to be sorting. I have recently discovered sorting through table relationships and I am hoping that by keeping the records permanently sorted it will speed up my users experience. I am trying to remove sort scripts from my scripts that are triggered by entering a layout (these records should always be sorted this way.) When disabling the sort from the script and using the sort from the table relationship, it appears that the records are not sorting even though I copied the sort criteria from the script directly into the relationship sort. Is there anything special I need to check out in relationships sorting? Thank you.