I'm using hosted Filemaker 14 server which I access via internet using Filemaker 16.
When I show any field from related table in list view, it takes few seconds to load. (It gets worse when I sort the records or use summarize field)
The solution I came up with is to create similar fields in the main table and copy the required data to the main table from the related table. (using psos)
This works but will blow up the size of database and there might be error if the related table changes it's data.
Any suggestions for speeding up the list view?