Working with related records in Filemaker have always been slow, but now I'm wondering....
I have a table with 6.000 records containing Orders and related Clients.
Sorting on the related Client Name takes a couple of minutes.
If I lookup the Client Name in the Order Table and sort on that it takes 1/10th of a second.
Something must be seriously wrong... All fields involved are indexed, and there's nothing strange really. As I mentioned, Filemaker is not very good at handling related data, but I don't know if I have noticed it this bad before...!?
To use a lookup is bad in soo many ways, and I don't want redundant data!
[FM Server and clients are version 15]