When evaluating a Global Field from an unrelated table, does FMP download the entire first record from FMS. Or does it only download the content of that Global Field?
That's a very interesting question. I seem to recall a Knowledge Base article that gave this as the reason for putting globals into their own table when not used as match fields in relationships.
But repeated attempts to find that article come up empty so I cannot confirm that this is actually the case.
Retrieving data ...