AnsweredAssumed Answered

Multi-Key Line Limit - 125 Lines (Seems to apply only to external SQL (ODBC) data sources)

Question asked by ntay on Sep 13, 2011
Latest reply on Sep 14, 2011 by ntay

Title

Multi-Key Line Limit - 125 Lines (Seems to apply only to external SQL (ODBC) data sources)

Post

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...

 

Multi-Key-Line-Limit.gif

Outcomes