Multi-Key Line Limit - 125 Lines (Seems to apply only to external SQL (ODBC) data sources)
I set up a relationship based on a multi-key text field. I'm finding that as soon as there are more than 125 values in the multi-key field, the portal showing the related records goes blank. If i delete a few lines from the multi-key field, the portal rows reaappear.
Is this behavior documented? It seems there should not be such a small limit on the number of lines you can have in a multi-key field before the relationship stops working.
I don't know if it matters, but a typical value in my multi-key field looks like this: "8653BD70-D309-4CBB-BFD8-84E8E0513C35".
Even 125 lines of this long id only amounts to about 4700 characters. It doesn't seem to be a limitation of the amount of text that can go into a text field...