7 Replies Latest reply on Sep 14, 2011 12:53 PM by ntay

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

    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