I have set up a Parent/Child linked list, each parent item can have multiple different child items linked to it. To connect child items to the parent I use a lookup field on a field on the parent list.
Ok, so my possible problem is this:
Ive read that SharePoint 2010 had a limit to 20 lookup items, however SharePoint 2013 has a threshold of 96 as far as I can see from this Software boundaries and limits for SharePoint 2013.
The thing is that over time the parent list will have several hundred items, and each parent item will have several linked child items.
I understand that that exceeding this threshold could have consequences on serverload, so is there any workaround for this? What I got so far is if I use something like SPServices i could populate a textfield with all ids from the parent list, and by that linking items, although only visually for the user.
Has anyone come over a similar problem? Any possible solutions?