Getting around the SharePoint LookUp column limit with Choice columns?
I'm aware of the 12 LookUp column limit in SP Online, but I really need more than that in my use case. I was wondering if anyone is aware of any potential workarounds?
I only need the columns to contain information from other lists, no need to cross reference them, so no deleting, or editing of original lists is required from the list containing the LookUp columns.
I was thinking maybe there could be a way to have a Choice column that would have values from a different list as options, but not sure how to get started on that. I can get it working as a Text column instead of Choice (having a ComboBox linked to the required list, then concatenating the result into the text data field), but would prefer a Choice column to allow for Filtering.